I had found a shortcut using TOTALYTD to force my pivot table to display via Fiscal Month order but I think that isn't dependable. I found the way to add a Fiscal Year and Fiscal Month to my Data Model (attachment Power Pivot Data Model) and it works except for 1 thing. The data is in the correct order but it displays the order number 1, 2, 3... instead of the name July, August, September... (attachment Pivot Table with FiscalMonth).
Is there a way to have the Pivot Table keep the order of the display using the FiscalMonth column but display the month name instead?
Use this forum for any general discussion and questions about Excel
1 post • Page 1 of 1
- Pivot Table with FiscalMonth column.png (63.84 KiB) Viewed 750 times
- Power Pivot Data Model with FiscalMonth column.png (73.76 KiB) Viewed 750 times
Who is online
Users browsing this forum: No registered users and 0 guests