Create a table with merged column

[rcqlik]

Hi, I'd like to create a table of which there is a new column that aggregates the previous column value.

There are 4 columns:

1. Name
2. Class Number
3. Module
4. Rating

The new column is the average rating, which will calculate rating from all classes that all teachers teach based on specific module.

Any idea on how to achieve that? Which type of visualization/formula that I should use?

[rcqlik]

I'm trying to use the formula

    Aggr(Avg([Rating]), [Module])

But it seems that it only show the value at one of the rows.
Possible to show the values across all the rows having the same module? Or merge the cells?

[Lisa_P]

You can use the nodistinct qualifier and it will go in all cells:

    Aggr(Nodistinct Avg([Rating]), [Module])

[saminea_ANZ]

Simply thing should also work
Sum(TOTAL <Module> Rating)