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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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