ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table-show Q3 and Q4 with non filtered Total (https://www.excelbanter.com/excel-discussion-misc-queries/251915-pivot-table-show-q3-q4-non-filtered-total.html)

Aldo

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.


All times are GMT +1. The time now is 05:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com