• 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.

Pivot Table: Formula to Remove a Component that makes up the "Total"

P

pj

New Member
The "Total" column in my data set sums figures from 20 other cells (it's an invoice that has 20 fees). To be included, it has to meet two conditions (Type of Transportation and Mode of Transportation). I want to remove (not use) one of the fee figures, but still sum the remaining ones. My plan is to include the Total figure, and then subtract the one fee I don't need.

How do I create the pivot table without including all of the individual fees? Thanks for your help.
 
Hi PJ
I suggest you post a file so it can be looked at to illustrate your goal. Perhaps with a mock up of the desired output ?

Gerry
 
You must log in or register to reply here.
Back
Top