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.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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