1 of 1 people found this helpful
Yea I'm not sure LOD is your best bet here. It makes a lot of situations much easier, but you shouldn't be creating 7 calculated fields. You are correct in that a parameter will offer global control for your sheet. Instead of your Index() filter, you should try:
[Sales Rank] <= [Avg of Top N parameter]. Also, if you put Sales Rank on the row shelf and hide the header, you'll be able to see the sum of sales for those top N sales.
Just want to make sure if there is a way that allows me to get rid of this fake filter trick. This does make things much more complicated, esp. all other calculations are based on this high average sales number. I had to drop manager and month index to almost every worksheet that I built and hide those unnecessary rows. Do you have alternatives to resolve this issue?
(The reason why I used index() over [Sales Rank] <= [Avg of Top N parameter] is that I do not necessarily want to show top n sales but just the high average sales for each manager (for example, this high average sales number will determine year end bonus for those managers).)