8 Replies Latest reply on Jun 13, 2018 11:33 AM by Mridula Tunga

# Rank based on row average

Hi,

I have a dataset with multiple columns(categories) for each user(email id) as shown in the screen shot. The categories are selected dynamically from the filter. I need to find a row average for each email id concerning all the selected categories and display the top 10 email Ids

Appreciate any help!

• ###### 2. Re: Rank based on row average

Hi Mridula,

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

• ###### 3. Re: Rank based on row average

Hi

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

Jim

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.

• ###### 4. Re: Rank based on row average

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.

• ###### 5. Re: Rank based on row average

I see you never posted a work book - please post your twbx workbook and we'll look at what you are doing

• ###### 6. Re: Rank based on row average

Hi Mridula,

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.

1 of 1 people found this helpful
• ###### 7. Re: Rank based on row average

I won't be able to post the workbook unfortunately because of data privacy, but I will be able to explain in words

• ###### 8. Re: Rank based on row average

This information really helped, thanks!