check the attached workbook instead of using index , i used concept of context filters
hope this helps,
plz mark this answer as correct or helpful to close thread
Order of Ops_v10.2.twbx 48.0 KB
see the attached
I've gone a different direction using lod's
this incorporates all your filters and the client - and returns the sum
this will rank the lod asc and the second is desc
I then added a parameter to set n
add the filter
on a single sheet will give you both the top and the bottom N
you would do the same the other measure and have 2 sheets in the dash and pass the filtered based on the eb4
and you get this
place them on the dashboard and they look like this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Order of Ops_v10.2.twbx 68.7 KB
This will take me a while to wade through, but it appears to do the trick. Obviously I am not a sophisticated user, and I don't often get into lods...in fact it took me a minute to remember what that stood for. ☺
I appreciate your help.
Well ****. I actually came across that concept, but I had it backward. Thank you for your effort. This appears to be a very simple solution to my problem.