Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have customer wise sales data per month. I have created a pivot table showing Customer Name Vs Monthwise sales.
Also sorted data decreasing manner for total sale per customer.
Data for first few customers shown below....
Customer Name | Month | Total | Jan | Feb | Mar | Apr | May | Dec |
Total | 7,569,868 | 866,396 | 917,070 | 904,956 | 660,191 | 1,284,303 | 639,091 | |
Customer 1 | 987,912 | 117,230 | 121,298 | 160,146 | 89,691 | 128,454 | 1,453 | |
Customer 2 | 743,881 | 179,022 | 62,593 | 56,743 | 118,122 | 96,074 | ||
Customer 3 | 524,923 | 6,537 | 109,203 | 89,726 | ||||
Customer 4 | 497,782 | 497,782 | ||||||
Customer 5 | 395,612 | 118,459 | 93,752 | 133,721 | 12,445 | 8,350 | ||
Customer 6 | 341,994 | 14,474 | 8,994 | 81,600 | 3,786 | 133,288 |
My problem is from above table December Month data is for 2010 while January to May months sale is for 2011.
So I need this pivot table should show data as DEC JAN FEB MAR APR MAY...
Please help...
Are your months defined like this?
month(Date) as Month
If so, that's why they don't sort with the year taken into account. To include the year, define your months as dates:
date(monthstart(Date),'MMM YYYY') as Month
You don't HAVE to include YYYY there, if you only want to show the month name, but I think it'll be confusing without it.
Hi,
You need to sort your Month Colum by Decending order then the pivot chart automatically display Dec,Jan,Feb,mar,Apr,May by Properties->Sort->Expression->Select Month column then select Descending order.
Regards,
Anand
It's not working
Are your months defined like this?
month(Date) as Month
If so, that's why they don't sort with the year taken into account. To include the year, define your months as dates:
date(monthstart(Date),'MMM YYYY') as Month
You don't HAVE to include YYYY there, if you only want to show the month name, but I think it'll be confusing without it.
Dear John, It's now working... Thanks for your help...