How to Filter Current vs. Previous Year Data Using a...

[#1]

Hi everyone!!

I’m working on a requirement in SAP Analytics Cloud where I need to use a single Posting Date input control to filter two different tables in a story. The first table should display data for the exact month selected by the user through that input control, while the second table should automatically show data for the same month in the previous year. Both tables use the same dimensions—G/L Account and Posting Date—and the measure Amount in Company Code. For example, if the user selects January 2025, the first table should show January 2025 data, while the second should show January 2024 data.

The challenge is that SAC applies the input control directly to the Posting Date dimension for both tables, and I need a way to “offset” the Posting Date filter by one year only for the second table. I’m looking for the best approach to achieve this,  any SAC feature that allows filtering one table based on a previous-year version of the selected date. If anyone has implemented something similar or knows an efficient workaround, I would really appreciate your guidance.

[N1kh1l]

@AhmadAzaanFarooqui 

One option is that you can create restricted measure based on dynamic time offset to previous year for the second table. The other option is that you can use scripting to read the Input control selection , offset it by a year and then pass it as a dimension filter to the second table.

Nikhil