Regarding Pivot table row wise average

[#1]

Hello Friends,

Your helps are always appreciated!

I have a pivot table in which I need a row wise average as like below,

id	15	18	19	20	21	22	23	24
	MGR2	MGR3	MGR4	MGR5	MGR6	MGR7	MGR8	MGR9	Average
Leadership
A	5	5	6	1	NA	2	7	4.3
B	3	4	6	2	7	4	6	4.6
C	4	5	4	5	7	3	3	4.4
D	4	6	6	2	6	4	4	4.6

Kindly share your ideas

Thanks,

Kiru

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling

[#3]

Thank you Gysbert!

[gerhard_jakubec]

Hi Kiru,

i am stuck on this topic for quite some time now.

My situation:

• pivot table
• 3 dimensions (time horizontal, others vertical)
• 1 expression = count(distinct [businessKey])

Requirement:

• expression total for vertical dimension totals
• average of column values by row for horizontal (time) dimension total

unfortunately I have not found a solution yet... good luck

[Clever_Anjos]

Please check if this solve your needs

[jonathandienst]

Hi

Use an expression with Dimensionality() (for row dimensions) and SecondaryDimensionality() (for column dimensions) like this:

If(Dimensionality() = 0,

  Count(Distinct businessKey),

  If(SecondaryDimensionality() = 0,

  Avg(Aggr(Count(Distinct businessKey), Dim1, Dim2, Dim3)),

  Count(Distinct businessKey)

  )

)

where Dim1, Dim2, and Dim3 are the three dimensions of the table. See attached for an example

Regards

Jonathan

[gerhard_jakubec]

Thank you, will test your proposed solutions.

kind regards