I have a calculated field as follows:
[Business]- (sum([Business ($)]))/ (TOTAL([Business ($)])))
The above field gives me % value of business share of different organizations computed down the table with the different organisations in the rows shelf and reporting month in columns shelf as follows (Not showing all rows):
Now, I need to calculate the difference between the above to columns to give me a result as follows:
The Key here is that I need to do a difference of my calculated field [Business] but this time across the table, so basically need a way to do percent difference across the table of a calculated measure which is done down the table.
I have tried the following but it yields incorrect result:
(([ Business ]))-LOOKUP([ Business ],-1)
You've talking about Nested Table Calculations.
Upon selecting your [Business] pill on a view,
please open the Edit Table Calculation dialog
and look at the Nested Calculations part.
You can set different Addressing & Partitioning
for each calculation within the Nested Calcs.
Hope it could help.