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

Top