TopN Filters (and Sets derived from them) work
when there are no other Dimensions in view --
as in your Coupon_Mode one.
As soon as one or more Dimensions are on a view,
things get complicated, and RANK Table Calcs are of help.
Please find the attached wb w/Sheet 7 as an example.
Hope I understand correctly what you're trying to accomplish.
That worked well. Thank you. Do you know why I am unable change the alias to Mode instead of Int_Rate_Dim? for this sheet? I assume it has something to do with it being an extract.
Do you really want to change the Values
of a blue pill Int_Rate_Dim on a view (Sheet 7)?
That's what Alias is for.
Or you may want to re-Name a pill Int_Rate_Dim
to change it's name for a Header on a view?
Then simply re-name the field in a data panel on the left.
Or I misunderstand something? Please correct.
Seems so. It could be better to make a copy of this field,
rename and use it in another view w/the same pills.