MrExcel on Excel - Pivot Table

[shades]

I am having a brain freeze (some say it comes with the age).

On pages 328-332 there are samples of PivotTables. Then on page 333, the PivotTable shows Percent columns for Quantity and Income. However, I have not found a way to add those columns and have the PivotTable automatically display the percents; and there are no instructions in the book about how that is done. I'm assuming that the percents are not in the underlying data table for the Pivot.

I'd appreciate any help you can give this old, dottering, semi-senile cowboy.

 

[starl]

skip ahead to page 336 to the section on adding calculated fields.

 

[shades]

Well, sort of... here's my brain freeze. We have columns for each week of data, and then in the rows we have Cons or Bus and then each of those is broken down into Creative slots. However, when I insert a calculated field it always shows up as another set of rows, rather than columns.

I know I am doing something idiotic and can't see the forest for the trees (or vs versa)

 

[starl]

.. can you send it to me?

 

[shades]

Let me temper the data, then I will forward.

 

[shades]

Thanks, starl. At least now I know I am not completely nuts. I think I will continue developing the VBA solution.

 

[shades]

After working with another XL guru in our company, we found the way to accomplish what we need - without VBA. In the end it was relatively simple, but hard to figure out in the dark.

 

[starl]

well! what's the answer!!!

 

[shades]

I dragged the field TRP onto the Pivot for a second data item. Then I chose "Field Settings" then "Options" in the middle, instead of normal in the dropdown I chose "% of Column". Then dragged the Data heading up and to the right of the Week heading. just like that. So simple.