Month wise New Dealer Volume

[anikkumarhole]

Hi Dear Frinds,

I have created below chart which give me month wise unique  new Dealer count

and Expression is:

=

Sum(Aggr(If(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month) = Min({<InvFiscal_Month = {'>=8'},[A/N]={'New'},Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month)

and

Min({<InvFiscal_Month = {'>=8'},[A/N]={'New'},Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month) >= 8,

If(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month) - 6 > Alt(Above(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month)), 0), 1, 0)), [DMS Outlet Code], Sort))

+

Sum(Aggr(If(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month) = Min({<InvFiscal_Month = {'<8'},Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month) ,

Count(DISTINCT {<[A/N]={'NEW'}>}[DMS Outlet Code])), InvFiscal_Month, [DMS Outlet Code]))

+

Sum(Aggr(If(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month) = Min({<InvFiscal_Month = {'>=8'},JEETPhase={'JEET Pilot'},[A/N]={'Active'},Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month) and

Min({<InvFiscal_Month = {'>=8'},JEETPhase={'JEET Pilot'},[A/N]={'Active'},Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month) >= 8, If(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month) - 6 > Alt(Above(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month)), 0), 1, 0)), [DMS Outlet Code], Sort))

+

Sum(Aggr(If(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month) = Min({<InvFiscal_Month,Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month) and

Min({<InvFiscal_Month,Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month) > 11,

Count(DISTINCT {<JEETPhase={'JEET 1.1'},[A/N]={'Active'},Month=,Quarter=>}[DMS Outlet Code])), InvFiscal_Month, [DMS Outlet Code]))

Using this Expression i want to show Month wise  New Dealer volume agents this count. in another chart.

Thanks & Regards,

Anik