Forum Discussion
Using data created in PowerBi pivot in new calculated values table
Hi Anonymous
Thanks for your response. I am still a bit confused. I have attached photos for reference. Say I have the data shown below:
I then create a pivot table from this data, as shown below:
Now lets say I want to use the values in this pivot table to generate new calculated values. For example, lets say I would like calculate the Cumulative vol percent for code A and B at score 80. So in this case I would want to look at the pivot table and take the sum of cells B2:B3 and D2:D3 and divide by the sum of cells B1:B3 and D1:D3.
And lets say I would like to repeat that process for the rest of the scores to create a new table that holds the Cumulative vol percent for code A and B for each score.
Essentially, I need to be able to reference the values in the pivot table to create a new table with calculated values. How can I do this in powerbi? If I were to do this in excel, the pivot table would be on another sheet called "Pivot" and the new table's calculated value would just be
=(SUM(Pivot!B2:B$3) + SUM(Pivot!D2:D$3))/(SUM(Pivot!B$1:B$3) + SUM(Pivot!D$1:D$3))
Any clarification on this would be much appreciated!
Thank you