GetpivotData to calculate a field in one pivot table as percentage of a field in another

Copper Contributor

I have a pivot table showing numbers of vulnerabilities like this:

Date   Critical    High   Medium

March 2345       5544   76547

 

Then another pivot table showing the number of vulnerabilities that we accepted risk on:

 

Date   Critical   High   Medium

March   56        67      444

 

I need to show the numbers of accepted risk as a percentage of total number of vulnerabilities. Can I use GetpivotData for this? Do I need to create a new table to show this? I see how I can show values as percentage if I drag them twice in the pivot table, but I can't understand how I pull an external value to the pivot table to calculate percentage on it.

Thank yo

0 Replies