Qlik Sense pivot table measure and dimensions in columns

[micsim123]

Hi

I have this pivot table with a column dimension: 7_scale_result.

I want to add a column with a measure of average af 7_scale_result. I can make this table, but obviously i only need the total average column and not the average of each grade.

Thanks in advance!

Michael

[rubenmarin]

Hi Michael, in properties panel (edit mode -> right panel), in the dimensions section yo have a check to 'Show totals'.

This option is shown in the first dimension, so maybe you need to drag 7_scale_result as the first dimension, change the setting, and drag again to second dimension.

[micsim123]

Hi Ruben

I tried, but can't get it to work.

In this table, I want to exclude the columns in red,so i only get the average.

My settings are:

Best regards

Michael

[rubenmarin]

Hi Michael, having a dimension below the measures causes to repeat all dimension values for each expression.

One way to avoid this is simulating the measures using another dimension. And using SecondaryDimensionality() you can select wich columns have to show.

I attach an example, maybe there is an easier way to do this.