Nectari Demandes d'amélioration

Status updated to 'Under review'

in fact, anywhere among the different columns

Needed for presenting variance calculations from a pivot set

Allows for better controlled presentation to the end users

Hi everyone,
Thanks for all these comments, it's helping us understanding the requirement you are having and it's really appreciated.
If your intend is to calculate variance between pivot set you can do this with the new "Windows Function" feature in the data model.
1. You create a new calculated column and you will use as an example the Windows Function "LAG", this function will return you the previous pivot data or previous row data if you don't have a pivot. So, if you pivot by Year and you got year 2020, 2021 and 2022 on each year you could have the data of the current year and the previous year in the pivot
2. You create a new calculated column of type "On Calculation" that will do the variance between the "LAG" column and the regular column...
That's it... you got your variance between pivot and they will appear inside the pivot for each different set of pivot.
Hope this help.
Thanks