Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am trying to show on a pivot a list of months for the last two years, but I want to be able to show as the name of the current month 'MonthName - MTD' to indicate it is not a full month. I've been hacking around with it for a while, and I got something like
=Month & if(Month = Date(Today(), 'MMM'), ' -MTD')
to work, but then the sort order of the months fails. Is there a way to manually then sort the months?
Thanks!
Hi,
If you can pad year/month ..then displaying the same in pivot table is easy ..you can sort the same numerically ...for eg. 201001, 201002, ...........200912,200910...
rgds
tapas
Thanks, but its a business requirement that it shows years, broken down into months in the format 'MMM' with the current month showing as 'MMM - MTD'.