#SAC Dynamic percentage calculation in table

[adriano1973]

Hello experts,

In SAC I have this kind of table where there at max 3 rows, and I want to calculate dinamically the variance % of the last row (in this case 2024 turnover) compared to preview one (in this case 2024 forecast)

I tried to add a row where I calculated in this moment in the formula bar what I need and it works, BUT, this table is dynamic because I can filter with a story filter the year, so in this case I selected 2024, but if select 2023 as example, the table correctly refreshes but the added row is completely wrong.

Does it exist a way to implement this and how? Alternatively how could I approch this matter?

Thank you

Adriano

[William_Yu]

I would suggest to create restricted measure/account on first 3 rows with input control( to select year), and create a calculated measure/account for the 4th row for variance calculation. 

[adriano1973]

Hi William, thank you for the support, can you show me in how should I do with some examples in detail? Thank you so much