SAC Story : Recent n Dates calculation

[krishnkant]

Hi Team,

I am working on a SAC Story(Optimized Design) based on a Datasphere live model*.

There is a measure named, Inventory Date*. My requirement is to display the latest/recent 10 dates from the Inventory date in the SAC table.

SAC Table Column would contain the latest 10 Inventory dates and Table row will have one measure value in row section of the table

Note:Extra Information

1.Inventory Date only displays the Monday's date . For example, for any of the dates among 7th ,8th,9th,10th May 2024, Inventory date would be 6th of may(i.e Monday).I have already created calculation to display only the Monday's date.

2.We are using a live model, so number of entries in Inventory date column may vary. We need the most recent 10 dates.

Please help me to achieve this calculation.

Regards,

Krishn Kant

[Lothar_Köder]

Hello @krishnkant,

Another approach could be to simple sort your table descending by the date and change the drill limitation to 10 columns:

You will see the most recent ten dates then.

Best regards

Lothar