Pivot Table – Change data type

akhlaq768 · #1 (**permalink**) 10-25-07, 07:45

I have a pivot table where the data is presented as a Count, I want to also it as a Percentage.

How do I create a button, which allows me to interchange between Count and Percentage?

Many thanks

shades · #2 (**permalink**) 10-25-07, 14:14

You could have both. Add the dame item to the data area of the Pivot, and right click and choose "Field Settings" and on the right side Click on Options, the drop down under "Show data as..." and select the drop down that is appropriate for your needs. It may take a little fiddling, but it will work.

akhlaq768 · #3 (**permalink**) 10-25-07, 14:54

Quote:

Originally Posted by shades

You could have both. Add the dame item to the data area of the Pivot, and right click and choose "Field Settings" and on the right side Click on Options, the drop down under "Show data as..." and select the drop down that is appropriate for your needs. It may take a little fiddling, but it will work.

How do I create a button, which allows me to interchange between Count and Percentage?