G
Garrett
In a pivot chart/table, when I group my date field by Month(in the properties
menu), the dates group correctly when I select the Month option in the
grouping menu. However, when I reopen the pivot chart, the Month identifiers
change to reflect dates such as 11/1/1901.
How can I get a pivot table or chart to reflect the appropriate Month or
Quarter and Year each time the chart is opened.
I am using the short date format in my data table.
menu), the dates group correctly when I select the Month option in the
grouping menu. However, when I reopen the pivot chart, the Month identifiers
change to reflect dates such as 11/1/1901.
How can I get a pivot table or chart to reflect the appropriate Month or
Quarter and Year each time the chart is opened.
I am using the short date format in my data table.