Hi Friends ,
I have a situtation , see below data
![Sample Data.png](/legacyfs/online/144475_Sample Data.png)
I dont want to show I priority in my dashboard , but value of I should be distribute like below
41% of I should add to A
59% of I should add to B
and for other dimensions like zone or some others , it should not happen , and i want to make pivot table for that .
How can i approach this solution.
Attaching sample data