ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Question (https://www.excelbanter.com/excel-discussion-misc-queries/186473-pivot-table-question.html)

Connie Martin

Pivot Table Question
 
In my data file I have a date column formatted MMM YYYY. In my pivot table
the date is in the Page field. By default it selects 'All', of course, but
in the dropdown list I have more than one APR 2008 because there was more
than one order in April 2008. How do I get the dropdown to show just one APR
2008 for all of the orders in that month instead of several APR 2008's?
Understand what I mean? Connie


All times are GMT +1. The time now is 03:50 PM.

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