Pivot table-show Q3 and Q4 with non filtered Total

A

Aldo

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