cumulative calculation without filter action

Question

How to perform cumulative total for the table without the effect of filters? I have added a year as a filter and want to see the yearly avg sales and profir vs past all year data.

Answer 1

Hi Sindhu,

You can have cumulative calculations without affecting filters by using LOD.

Syntax: { FIXED [FIELD_NAME] : AGGREGATION(FIELD) }

As per your question. we can find the average for all years.

{ FIXED : AVG([Sales]) }

similarly, profit as   { FIXED : AVG([Profit]) }

Place the created field in sheet to see the avg sales year wise vs all years.

Hope it helps you.