Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have attached a qvw please let me know if you require any further explainations
I think the chart in the attached should give you what you need.
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
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
Hi Mohammad, see if my solution works for you
your solution only works for the max year. if i select 2007 it doesn't work.
I think the chart in the attached should give you what you need.
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