1 of 1 people found this helpful
Shot in the dark, but did you try putting your first filter as a context filter? I think this would work
That's brilliant -- hadn't tried it, but it looks like context filters don't work on table calcs .. so since index() is a table calc, it wouldn't allow me to add the first filter into context. But I was not aware of the context filter in the first place! Very helpful
The conclusion was to turn the first index() into a parameter with an integer range. Then I set up a filter for the second index() with the TOP function.
The syntax was "Top [first param] by [first param's measurement] [aggregation type]"
I think my question was a little too specific, but that context filter thing will be my ace in the hole next round