ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How I can add categories in a pivot table? (https://www.excelbanter.com/excel-worksheet-functions/7282-how-i-can-add-categories-pivot-table.html)

Todd L. December 1st 04 06:19 AM

How I can add categories in a pivot table?
I have two questions:

First One-

Can I group and then sum categories included in a pivot table report?

I have a table which lists which divisions bought what, now I need to group
those products by the manufacturer. In the same table if possible. The data
is right there but I can't figure how to do it. Can I insert a calculated
field in my table and group them? I have no more than 7 sub-categories to
add together and 3 possible groups.

Second One

My pivot table has a field that counts all the other entries and its
calculating wrong. Its missing 32 entries (out of 1500). ??? Any ideas
what might cause that?


Todd L.

All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.