Mar 06 2022 06:34 PM
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