Need to Have MTD and YTD Calculations at the same time in a Single Pivot Table

[all4excel]

Dear Forum,

I have a report where I need to show the Sales Performance in the MTD as well as YTD format. MTD- Month TO Date and YTD- Year To Date Numbers in the same report.
I have a certain number of Files for a period beginning from 1-Jan-17 till 31-Mar-19. In India we refer the business from 1-Apr-XX to 31-Mar-XX+1 where XX can be any Year.
So I just need to select any month for MTD i.e Mar-19 so I get the No of Files done in the month of March-19 only as well as I need in YTD Total Files starting from 1-Apr-18 till 31-Mar-19.

My Pivot Table has Month - MTD i.e Mar-19 selected to be interpreted as 31-Mar-19 and in the Rows - Have the Branch Names - Mumbai, Delhi, Bangalore etc. and in the Data Field I have the Sum of FIles Nos. I am getting the MTD - No of FIles but unable to get YTD FIles.

Need your help.

Thanks in advance

 

[all4excel]

Bump a Thread

 

[all4excel]

Hi is it possible to have both MTD and YTD in the same pivot ?