Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi all,
I need help with a pivot table. This is what I have: (country and zip code are Column Area, while orders is Data) COUNTRY ZIP CODE ORDERS DE 1345 10 DE 1485 5 DE 1887 12 DE total 27 IT 20145 4 IT 20455 9 IT total 13 Grand total 40 And this is what I need: (below the ZIP CODE column, in the row where there is the subtotal for the orders, I need the count of how many zip codes are considered per country) COUNTRY ZIP CODE ORDERS DE 1345 10 DE 1485 5 DE 1887 12 DE total 3 27 IT 20145 4 IT 20455 9 IT total 2 13 Grand total 40 Does anybody know how to obtain this result? Maybe with a function in a calculated field? any help very much appreciated. Massimo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
Pivot Table Customize functions in the Data Field | Excel Discussion (Misc queries) | |||
Advise on Pivot Table & Functions | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |