Hey there,
So I have a Pivot Table which has a few slicers. I want to insert a field that shows the % count of the total amount...
Example - lets say I have a column of data that is the following colors: red, red, orange, orange, orange, yellow, yellow, yellow, blue, and blue. When I select orange in the slicer, the count shows 3. What I also want is a column that shows 30% for when I've selected orange (and 20% for red, and so on). I can't seem to figure out how to display this, but it seems possible. Thanks for your help!
So I have a Pivot Table which has a few slicers. I want to insert a field that shows the % count of the total amount...
Example - lets say I have a column of data that is the following colors: red, red, orange, orange, orange, yellow, yellow, yellow, blue, and blue. When I select orange in the slicer, the count shows 3. What I also want is a column that shows 30% for when I've selected orange (and 20% for red, and so on). I can't seem to figure out how to display this, but it seems possible. Thanks for your help!