View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aldo Aldo is offline
external usenet poster
 
Posts: 16
Default Pivot table-show Q3 and Q4 with non filtered Total

Hi guys,
Need help with the question detailed below.

In my Pivot Table:
Field "Qty" is xlDataField.
Field "Quarter" is xlColumnField.
The report shows the quantities for each quarter, like:
Q1 Q2 Q3 Q4 Total
2 5 4 5 16

I need to show only Q3 and Q4, but live the "Total" with the whole quantity,
like:

Q3 Q4 Total
4 5 16

How can I achieve that?
Thanks in advance,
Aldo.