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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table-show Q3 and Q4 with non filtered Total 0
Rank in Pivot Table 4
Use icon sets relatively in a pivot table 1
changing year grouping in pivot table 4
Sort Pivot by Year 8
How to distribute/spread/map cost of project across different year 3
pivot table - show ALL detail? 3
Average If, with a Moving Target 0

Top