Please use below screenshot as guide. You'll need to sort using the Month/Year of your data. Look where the cursor is in the below and then click sort on the icon when it appears for that Month/Year. Kentucky is actually higher than California for January 2014. If this answers your question please mark it as correct. Thx, Don
1 of 1 people found this helpful
Please follow these steps:
1. Create index field
2. Make it discrete
3. drag it before State
4. Lastly, change the compute using and sort like this
5. Hide the header for Index
PLEASE SET THE ANSWER TO CORRECT ANSWER IF IT SOLVES YOUR QUERY
Hi Don Wise,
Thank you for your prompt response on my query.
Yes your right Kentucky is actually higher than California for Jan 2014. How we can do that could please attach sample workbook.
Thank you very much your prompt response.
Actually In year& month column will come recent year month first.
Example : We are in Sep 2108 we have data till Aug 2018 only. So In year & month column first row will be recent month and year.
We need to see recent month& year wise City sales "Desc"' (Row Desc).
Just circling back to see if your question was answered by either me or Nitin? If yes, please mark the person's response as correct to close the thread. Thanks, Don