Pl attach a workbook to help you.
Add up all the columns in a calculated field and divide by 6 . Use Rank_Dense on that calculated field and you can use that field to filter for top 10 emails
see the attached superstore example
I used customer name and year of order date
the fixed sales are
the average per year is
and the rank is
It returns 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.
My problem is that I don't have fixed Measures to put a formula in the calculated field, user can select any set of Measure Values from the filter and I need to calculate average for all the selected measure values for each email Id and then rank.
I see you never posted a work book - please post your twbx workbook and we'll look at what you are doing
1 of 1 people found this helpful
If you need such dynamic calculation. You need to pivot your data and you can use that dimension to show data from which ever columns the user likes to .
And you can calculate a dense rank of table across avg. at that point which would help your case.
I won't be able to post the workbook unfortunately because of data privacy, but I will be able to explain in words
This information really helped, thanks!