Hi, I have a pivot table with 3 columns the first being an item the second is a dollar value and the 3rd is the same dollar value but shown in a running total %
I want to ad a fourth column to tell me if the % in the row in that item is below 79.99% then it is a top item and if not it a non top item
Row Labels Total GP$ Running % Rank
product 1 51410.8 1.56% Top Item
product 2 31132.32 2.50% top item
product 3 25962.41 3.28% Top item
product 5 23197.92 3.98% top Item
product 6 238.16 89.44% Non Top Item
I want to ad a fourth column to tell me if the % in the row in that item is below 79.99% then it is a top item and if not it a non top item
Row Labels Total GP$ Running % Rank
product 1 51410.8 1.56% Top Item
product 2 31132.32 2.50% top item
product 3 25962.41 3.28% Top item
product 5 23197.92 3.98% top Item
product 6 238.16 89.44% Non Top Item