Average Calculation

[nuwanhwb87]

Hi ,

i Have Below data

Dimension : Month

Expressions :  Efficiency , Running Machine, Quality Rate

Got the below format Chart object by a pivot Table by moving Dimension column Horizontally.

But not have and option to get the Yellow Highlighted Average/total Column.

1.1 Average Efficiency of all Months

1.2  Total Running Machines of all the months

1.3 Average Quality Rate of all months

Please Help???

[MayilVahanan]

Hi @nuwanhwb87 

You can refer the below link

https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-Add-total-and-distribution-field-in-pivot-tab...

[nuwanhwb87]

Hi ,

how do i get this.

Is it a seperate query or????

Can you please explain further