| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need the grand total pivot table filtered worksheet? | Excel Discussion (Misc queries) | |||
| Show current Report Filtered in Pivot Chart | Excel Discussion (Misc queries) | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| show only the subtotals and grand total in a pivot table | Excel Worksheet Functions | |||
| How can I show the total sum of items in a filtered column | Excel Worksheet Functions | |||
Linear Mode
