BookmarkSubscribeRSS Feed
SiMor
Calcite | Level 5

Hi, 

i need some help with the measure of stock. 

For each timeframe, month, quarter and year i need to sum just the value of the last month in the timeframe so that the value of march 2019 is the same of the first quarter of 2019. 

 

Could someone help me?

 

Thank you

 

 

1 REPLY 1
FredrikE
Rhodochrosite | Level 12

I have solved it by using a calculated dimension for time. I have a button bar with the different possible time dimensions (day, month, quarter and year) I have assigned a parameter to the button bar.

 

In my graph objects i use this calculated dimension as category.

On the objects I have created a dynamic filter that uses the parameter to decide which time period to show.

 

In my data i have a flag for last day of month, last day of quarter and last day of year. I use these in the dynamic filter

 

//Fredrik

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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
  • 1 reply
  • 472 views
  • 0 likes
  • 2 in conversation