BookmarkSubscribeRSS Feed
FrankE
Fluorite | Level 6

I have a dataset that includes several periods of data with a period end balance on each record.  My VA report has a period slider at the top that I can use to select the date range for the report.  I'm looking to display the current balance as of the upper bound of the date slider.  I believe this would be considered a semi-additive measure?  Can someone point me in the direction as how to handle this?

 

Example:

CustomerID      Period       Balance

1234                 Jan2001    $300

1234                 Feb2001   $100

1234                 Mar2001   $300

 

Just using the default aggregation, the field would show the sum of the rows included by the slider.  What I want is the balance as of the end of the slider.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 0 replies
  • 323 views
  • 0 likes
  • 1 in conversation