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