I need help in finding the products who were top ten in the last year but not in the top 10 of current year

[Anonymous]

I have attached a qvw please let me know if you require any further explainations

[SunilChauhan]

Hi

your app is not opening

but you can follow below

in dimesion take  Product field

in expression write

sum({<Year={$(=Year(today())-1)}>} amountfield)

in presentation  max visible number 10

sort check y value

hope this helps

Sunil

[Anonymous]

Sunil your expression only returns the top 10 products of last year. i have to build an expression which returns those products which were part of top 10 products last year but not this year sort of speaking recall the method in sets called intersection if a=last year and b=current year then i have to build B - A

[#4]

Hi Mohammad, see if my solution works for you

[Anonymous]

your solution only works for the max year. if i select 2007 it doesn't work.

[Nicole-Smith · Accepted solution]

I think the chart in the attached should give you what you need.

[Anonymous]

Hi Nicole,

Thanks for response. your answer is correct, I used almost the same formula but didn't used alt() function.

Thanks again,

Regards,

Irfan