Suggest an idea
Suggest an idea
What would make Nectari Software more useful to you?
14
Be able to move the calculated pivot column at the end of the worksheet
worksheet
Under review
November 15, 2022
Actually the calculated pivot can only be place at the beginning of the worksheet (before the pivoted values), we would like to be able to put it also at the end.
5 Comments
Rakavy Ravisingam
2 years, 332 days ago
Status updated to 'Under review'
Reply
G
2 years, 326 days ago
in fact, anywhere among the different columns
Reply
Parocon
2 years, 326 days ago
Needed for presenting variance calculations from a pivot set
Reply
David Charles
2 years, 326 days ago
Allows for better controlled presentation to the end users
Reply
Guy
2 years, 326 days ago
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
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
Reply
Thanks for your feedback