• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculating field in pivot tables

G

GN0001

Member
I want to build a calculated field in Excel, I put a column header (category A) in Filter section of pivot table. Then do a filter on several fields which are in category A. Now I want to get the total of these several fields. How can I do that? Any help or any thought?

Guity
 
Guity,


The standard Row and Column Grand Totals for the Pivot updates when you apply the filters, is this not helping?


~VijaySharma
 
Hello Vijay,

I need to get the total for several items in a column.


I have a sheet as below:


Category A Category B Category C

1 Apple AA Pink


2 Orange CC Blue

3 Orange CC Pink


4 Kiwi DD Yellow


I insert a pivot table to have Category A, Category B and then I need the the total of Pink in Category C for all items in category A.


Imagine I have 4000 Rows.

Thank you for the help.
 
I have no idea how this is not posted in the right place. So I am sending this one more time. Because I need it.
 
You must log in or register to reply here.
Back
Top