How I can add categories in a pivot table?
I have two questions:
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.
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?
|All times are GMT +1. The time now is 02:10 PM.|
Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.