Complex Dynamic Calculation

[lalitinmbd]

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.

[MK_QSL]

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,', ')

[#3 · Accepted solution]

Hi,

Find the attached solution and let me know if it is suitable.

Thanks,

Prabhu

[mahesh_agrawal]

Hi Lalit,

Please find the attached .QVW file. I have used your Excelsheet as source.

I hope it answers your problem.

[lalitinmbd]

Thanks alot Prabhu. It worked perfectly....