Story Calculations in SAP Analytics Cloud

[Sumalini]

Hi All,

Based on user given input in the variable as date, i have display 15year sales data as below

Could someone please give an idea on how can i achieve this?

[William_Yu · Accepted solution]

Suggestions, create 5 restricted measure on perids with range of 12*15 periods and offsets(for later 4 measures). 

[Sumalini · Accepted solution]

Hi William,

Thank you for your reply. Here we are hardcoding the Offset Time Interval, in the Range Selections of Input Control.

Where can  we capture the user selection.? For example, user selects 2022, i have to calculate 15 year Cumulative data based 2022.

Could you please provide any suggestion?

[William_Yu · Accepted solution]

No, the time range is NOT hard coded in my proposal, it's story date picker generated from the 'Current date' section on the upper part of the screenshot. Just try it out.

[Sumalini · Accepted solution]

Hi William, How can i make the Period(with Calendar) available on the top of the Story, as you did in the above reply. So my user can select particular year. For Story Filters/Input Control, i can only give my available Dimensions. 

[Sumalini · Accepted solution]

Hi William, Thank you so much for solution.