Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? Thanks, Todd L. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a formula to a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |