![]() |
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