I want matched code for particular month and previous to previous month...

[kavita25]

I want those count where the code has sale for particular month and previous to previous month...not for previous month...

For.e.g- Jul  = Jul+May(Matching code)

            Aug = Aug+Jun

            Sep = Sep+Jul    

            Oct  = Oct+Aug

and so on...

Regards,

Kavita

[tresesco]

Now I notice that you mentioned about month as dimension. That would not work with this set analysis, because set analysis would generate one max/min value for entire chart, whereas you would probably want it month-wise. Hence, this set analysis would not be an option for you here.

[kavita25]

Even if i Select Year it show different values.

[kavita25]

tresesco‌

Is there any other option from back end...

For 1 month matching codes, i used this logic from back end..

If([DMS Outlet Code] = Previous( [DMS Outlet Code]),Previous(MonthCounter) - MonthCounter ) as ReturningAfter

In front end i used this :

count({<ReturningAfter = {">0<=1"}>})

I am not getting how will I skip previous month...from the back end..

Please help me with this..

[tresesco]

May be like this :

T1:

LOAD AutoNumber([DMS Outlet Code]&MonthName(Date#([Invoice Date],'DD MMM YYYY'))) As KEY,

  Region,

    [Distributor Code],

    [DSR Code/FMR Code],

    [DMS Outlet Code],

    [Outlet Code],

    [Outlet Name],

    [Sub-Channel Code],

    [Invoice No.],

    Date(Date#([Invoice Date],'DD MMM YYYY')) as [Invoice Date],

    Month(Date#([Invoice Date],'DD MMM YYYY')) as [Invoice Month],

    Year(Date#([Invoice Date],'DD MMM YYYY')) as [Invoice Year],

    MonthName(Date#([Invoice Date],'DD MMM YYYY')) as MonthYear,

    [Batch No],

    [Order SKUCode],

    [QTY in Ltr],

    [Turn Over without VAT],

    VAT,

    [Total Turn Over]

FROM

[SalesDummp (1).qvd]

(qvd);

Join

Load Distinct

  AutoNumber([DMS Outlet Code]&MonthName(Date#([Invoice Date],'DD MMM YYYY'),2)) As KEY,

  1 as Flag

Resident T1;