PivotTable - show all, subtotal some?

  • Thread starter Thread starter jg70124
  • Start date Start date
J

jg70124

I keep my sales pipeline in Excel XP, and have used a pivot table to
summarize the data.

I have a field (column) in my data called "Pipeline Status". Values in that
field can be "Sold", "Proposed", "Lead", or "Dead".

I want my pivot table to show columns for all those values, but create a
total only for "Sold", "Proposed", and "Lead" - that is, I want to leave the
dead ones out of the total.

Is there a way to do that?

Thanks...
 
You could create a calculated item:

Select a the Pipeline Status field button
On the PivotTable toolbar, choose PivotTable>Formulas>Calculated Item
Type a name, e.g. Active
Type a formula, e.g.: =Sold+Proposed+Lead
Click OK
 
Back
Top