Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I want to show those customers who was repeated in next month..
Please help me with this issue..
Its really very very urgent....
Regards,
Kavita
I have already mentioned my problem....in the previous reply...
and i have attached the data also..
Kinldy check the qvw.
Its very urgent for me to do this by EOD.
Search the forum for NEW, LOST, RETURNING customers, it seems you want to show something like this.
There are multiple approaches, if you want to compare fixed periods, you can also try set analysis: For example, to show outlets that had no sale in max month but sale in max month -2, something like
=Count(
{<[DMS Outlet Code] =
e({<InvMonth = {"=InvMonth=$(=Max({1}InvMonth))"}>})*p({<InvMonth = {"=InvMonth=$(=Max({1}InvMonth))-2"}>} )
>}
DISTINCT [DMS Outlet Code])
Thanks a lott..Stefan..
Really thankful to you..for all the solutions...
Regards,
Kavita