Dropouts Calculation...

[#1]

I am developing a QV application wherein i am actually calculating the dropout customers for the current month ie the customers who have shopped in the last month . but not in the current month. I have to put the field Month as my dimension. Can anybody suggest me how to do the same? SO i have months coming as my columns against which i have to calculate the dropouts....Please help if anybody has any particular logic fr the same. Thanks Neeraj

[amit_shetty78]

Neeraj, Pls see if this is what you are trying to implement.

cheers, Amit.

[#3]

Hey Amit,

Its somewhat near to my requirement but nt exactly the same..May be the data representation of the report is a bit tricky.

attached in an excel sheet.

rgds

neeraj

[#4]

Hi Neeraj,

Check the attached example and please let me if it helps.

- Sridhar

[#5]

Hi Neeraj,

One more solution.

I believe this should defenitely help you.

Check and let me know.

- Sridhar

[amit_shetty78]

Neeraj,

Can you tell us exactly what you want to achieve as result from the data.

-Amit.