Top 100 Customer who are there in previous Year not in Current Year

[deepakk]

Hi ,

I want to Display Customer who are there in Previous year top 100 and not there in currentb year top 100...

Any one has made such application then please do forward it to me.

Thanks & Regards

Deepak

[#2]

Hi Milda!

I've tried to make a table, which shows last items (lowest sales). What i've changed: I have added minus (-) sign in calculated dimension. But I don't know if this will be ok for you. --> Yes, I saw the minus(-) sign.

Go to the "Last top" tab. There I've created 2 similar tables. The only difference is that in the first table expression I've added +1. --> I could not see where you have added +1 in the first table expression. There is a strange thing: for example, when you select Year 2009, in the second table you will see that "item no" begins from 76. The reason: there are 75 items with 0 sales (in 2008). --> I want the item no begins from 1 where the least comes first and then so on. I think it's better to ignore the zero's and show only those items where sales value is there.

I want to have the same thing as it is in the top tab. But instead of top i want the last. I need all the four tables like that.

Thanks for your effort!

Regards,

Rikab

[#3]

Look at the picture:

[#4]

Yes saw it only after posting it.. Requesting to check rest of the things. I need the same one what was there in the Top tab.

[#5]

I've created one more tab "Last top100" (similar to Top tab).

But the problem still exists: you can't see the items which sales=0. For this reason I've made Last TOP100 (instead of Last TOP10).

[#6]

Hi Milda!

I think you have missed out my last reply for your post. Anyway have added it again below.

What we will do is better to ignore the items with sales value=0 and show only those items with sale value more that 0. In that case i think it should be possible. One more important thing which i want i the ranking. The ranking no should start from 1 and then so on. Because in your document it starts from different numbers.

~~~~~~~~~~~~~~~~~~~~~~

There is a strange thing: for example, when you select Year 2009, in the second table you will see that "item no" begins from 76. The reason: there are 75 items with 0 sales (in 2008). --> I want the item no begins from 1 where the least comes first and then so on. I think it's better to ignore the zero's and show only those items where sales value is there.

I want to have the same thing as it is in the top tab. But instead of top i want the last. I need all the four tables like that.

Thanks for your effort!

Regards,

Rikab

[#7]

Hi Milda!

Sorry to disturb you again! Did you worked around on this again? If you have got any other solution please do let me know.

Thanks and Regards,

Rikab

[#8]

Hi Rikab,

I still don't know how to skip zero (0) values and start numbering from 1. If I find the solution, I will tell you 🙂

Milda

[#9]

Ok fine... I am also checking with different logic... Will let you know if it works out...

[#10]

Hi Rikab, I have found the solution. But I can't attach the file. So maybe you can give me your email address?

[#11]

Gr8 thankyou... Please take down my email id... rikab@c2info.com Waiting for your mail!