Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a list of 50 measures, I need to change my pivot table, to add the ratio of each of this measure on [NET SALES].
To reference an expression, I can ether use its label ex: =[NET SALES] or its position = Column(1)
I assume I will have to add 50 entries in my pivot table, but I wish they share the same formula (that I can put later as a variable) such as
=Column(CurrentPosition-1)/[NET SALES]
How can I retrieve the current position of an expression?
NET SALES | |
Cost of Sales | |
%NET SALES | =[Cost of Sales]/[NET SALES] |
Warehousing | |
%NET SALES | =[Warehousing]/[NET SALES] |
Freight & Delivery | |
%NET SALES | =[Freight & Delivery]/[NET SALES] |
...
can you attache the sample app for the same?