Help Please with calculating large data in Pivot Table
Closed
r71lima
TrowaD
- Posts
- 3
- Registration date
- Saturday August 3, 2013
- Status
- Member
- Last seen
- August 4, 2013
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Help Please with calculating large data in Pivot Table
- Copy data from pivot table to another sheet automatically - Guide
- Extract data from pivot table to another sheet vba - Forum - Excel
- Calculate due date in access table - Forum - Office Software
- How to change the date format in pivot table - Guide
- VBA to refresh all pivot tables ✓ - Forum - Excel
1 reply
TrowaD
Aug 5, 2013 at 11:43 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Aug 5, 2013 at 11:43 AM
Hi R71lima,
Let me know what you think of the following:
Creating named ranges:
With your example A3:A16 is named MODELID (same as the header)
B3:B16 is named color and so on.
Cell J3: Is dropdown list to choose header (Model, color, etc....)
Cell J4: You type in the specification (i.e. for color choose RE/BK or GY/BK or ....)
Cell J7: Contains formula which shows result.
So basically choose category, choose what you want to count within the category and see the result.
The above is applied in the following file:
http://www.ge.tt/7nspf2o/v/0?c
Best regards,
Trowa
Let me know what you think of the following:
Creating named ranges:
With your example A3:A16 is named MODELID (same as the header)
B3:B16 is named color and so on.
Cell J3: Is dropdown list to choose header (Model, color, etc....)
Cell J4: You type in the specification (i.e. for color choose RE/BK or GY/BK or ....)
Cell J7: Contains formula which shows result.
So basically choose category, choose what you want to count within the category and see the result.
The above is applied in the following file:
http://www.ge.tt/7nspf2o/v/0?c
Best regards,
Trowa