Average row in bottom of table plus existing Total row

[Joe_]

Hey Qlik Sense community, 

I havent found answer for my specific question.

I just need an average row under Totals that shows the average of all the columns, I only showed 2 but there will be more

Is that possible? 

Best regards

[vinieme12]

Create a dummy Dimension in your datamodel 

example

PivotDummy:

Load * inline [

Dim,so_Dim

Date,1

Average,2

Total,3

];

 Then in Chart  

Dimension

=Pick(so_Dim,Date,Dim,Dim)

Expressions

No Of Order =Pick(so_Dim , count(Distinct Order) , Expression For Average Order , count(Distinct Order)  )

No Of Line=Pick(so_Dim , count(Distinct Lines) , Expression For Average Lines , count(Distinct Lines)  )

And Disable TOTALS row