-
1. Re: Comparative ranks - for two diff periods(monthly/yearly) based on total sale
diego.medrano Feb 1, 2017 2:02 PM (in response to Mohammed Ali Hussain)Hey Mohammed,
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.
Thanks,
-Diego
-
2. Re: Comparative ranks - for two diff periods(monthly/yearly) based on total sale
Mohammed Ali Hussain Feb 2, 2017 6:11 AM (in response to diego.medrano)Hello Diego
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.
Thanks.
Mohammed Ali
-
Ranking sample Query.xlsx 693.3 KB
-
3. Re: Comparative ranks - for two diff periods(monthly/yearly) based on total sale
Mohammed Ali Hussain Feb 9, 2017 12:07 AM (in response to diego.medrano)Hi Diego,
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.
Thanks
Ali
-
Rank Trial 1.twbx 1.2 MB
-