You should use the index and parameter related calculated field on only one worksheet where you want to reflect "TOP N" values.
On the other sheets the same calculated field or index should not be used or repeated!
thanks for the respond,
i switched from index to parameter so i could use the number in the tittle.
is there a way of geting the current number (the top N number) when using the index calculated field?
1 of 1 people found this helpful
Problem is Index starts from 0 to N numbers but parameter values range start from 1 to N.
On the calculated field, try something like
Index() <= Parameter.value
If you want the exact number as in the parameter value,write
Index() >= Parameter.value