Data Model Calendar has Fiscal Month field, but display Month name

Use this forum for any general discussion and questions about Excel
nhl66pens
Posts: 3
Joined: Wed Feb 12, 2020 11:11 pm

Data Model Calendar has Fiscal Month field, but display Month name

Postby nhl66pens » Thu Feb 27, 2020 2:15 am

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?
Attachments
Pivot Table with FiscalMonth column.png
Pivot Table with FiscalMonth column.png (63.84 KiB) Viewed 713 times
Power Pivot Data Model with FiscalMonth column.png
Power Pivot Data Model with FiscalMonth column.png (73.76 KiB) Viewed 713 times

Return to “Excel”

Who is online

Users browsing this forum: No registered users and 1 guest

cron