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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 716 views
  • 0 likes
  • 1 in conversation