Could you tell us what you've tried and what isn't working? You should be able to do this but we could use more information about the specific goal and roadblocks.
To elaborate the query, I have attached the file which contains two sheets the raw data and desired output.
Raw data - contains the client and site wise two year operational information for FY 16 (as on Nov 16) & FY 15.
Desired out - explained in below steps:-
- Column A,B,C & D - Contains Client and Site wise comparative ranking for period as on Nov-16 and as on Oct-16. The ranking is calculated on chargeable weight amount in descending order.
- Column E,F,G,H,I & J - Contains Chargeable weight, Revenue & Profit have the data for FY-16 and FY 15.
Ranking sample Query.xlsx 693.3 KB
Trust you are well?
I'm really sorry, if my previous question was inappropriate/uninterested.
I'm very new to Tableau, with little research and some efforts I was able to create a text table with consolidated sales amount and ranks for the month.
I have to submit this report every month and if November 2016 I'm submitting the report It should have two rank columns for October 16 and November 16 based on sales from January 2016 to October 2016 and January 2016 to November 2016.
In short I'm getting the ranks for the month. Where I want it for the period/as on date from beginning of the year to current month.
Please see the attached working.
Rank Trial 1.twbx 1.2 MB