We have a requirement where the user should be able to se the reduced data, but there should not be drop in the Total Volume, which is based on other data as well.
Suppose, we have a KPI saying total volume as sum(vol), then when we are reducing the application for one user, there is a reduction in sum(vol) as well.
Is there is any way, we can show the total volume to user.
The simplest way is to create a total volume field pre-aggregated at an appropriate aggregation level* and linked to a generic value of the field used for reduction. The SA table should automatically include a the generic value for all users.
*The "appropriate level" could be at the same level of granularity in the source data, except aggregated across the values of the field used for reduction.
You may have to explain to the users why the total is not same as the total sum of rows int their tables, and/or you could calculate an 'Others' value by subtracting all the known (reduced) amounts from the generic total.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
