Hi Milda!
That was a gr8 effort from you. It works perfectly! Coming back to your earlier post i have doubts on expression which you have used. Hope you will help me !
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hi Rikab,
The hole expression is quite simple. I sum(values) and then use rank() function to sort the result from biggest to smallest. Then (if I want top 10) I show only these rows where the rank() <=10. I am able to understand the what sum(sales) and rank() does. But it will be helpful for me if you can explain me with your expression.
aggr function creates lots of confusion for me. I am not able to understand how it works. I also checked that with the reference manual but it is not helping me.
=IF(
aggr(
rank(total
aggr( sum( {$<Year={$(=Max(Year)-1)}>} SalValue),itemname)
,0,1)
,itemname)
<=10,
aggr(
rank(total
aggr( sum( {$<Year={$(=Max(Year)-1)}>} SalValue),itemname)
,0,1)
,
itemname))
The first version of my formula was not quite good because it worked only with these items, which were in boath years ( if they were and in 2008 and in 2009). But the problem was with new items: the items which appeared only in 2009, and wasn't in 2008. So for this reason i used IsNull() function to test if the item is new.
Hope this will be helpfull and understandable 🙂
Milda
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Rest of the things i will get cleared after the basin part is cleared!
Thanks and Regards,
Rikab
