Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have come across the requirement on which i need help. Below is the scenario
I am here by attaching an excel which contains the date wise Dealer wise Sales. I need the count of those dealers who has done sales at least 6 months in the last one year (this bracket should change as per the user selection e.g Let say user has selected 2013 feb then i need count of dealers who has done sales for at least 6 months in Feb 2012 to Jan 2013).
Any idea guys how to do this.
Thanks in Advance.
Hi,
Find the attached solution and let me know if it is suitable.
Thanks,
Prabhu
Please check enclosed file...
UPDATE
If you are using my file.. you can get no of Dealers with name by writing below code in text box...
='There are : '&COUNT({<MonthID = {">=$(=Max(MonthID)-5)<=$(=Max(MonthID))"}>}Distinct Dealer) & ' Dealers : '&
CONCAT({<MonthID = {">=$(=Max(MonthID)-5)<=$(=Max(MonthID))"}>}Distinct Dealer,', ')
Hi,
Find the attached solution and let me know if it is suitable.
Thanks,
Prabhu
Hi Lalit,
Please find the attached .QVW file. I have used your Excelsheet as source.
I hope it answers your problem.
Thanks alot Prabhu. It worked perfectly....