Hi Friends ,
I have a situtation , see below data
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