Hide Expression in Pivot table without hiding its Total (URGENT)

[#1]

Hi Folks,

I have below sample table in my dashboard:

Col1	Col2	Col3
A	X	10
B	Y	20
C	X	30
D	Y	40

Using SUM() and AVG() over data and pivoting Col2 I got below o/p:

Col2	X	X	Y	Y	Total	Total
Col1	SUM	AVG	SUM	AVG	SUM	AVG
A	10	10			10	10
B			20	20	20	20
C	30	30			30	30
D			40	40	40	40
Total	40	20	60	30	100	25

I need to hide AVG expression without supressing its Total as shown below:

Col2	X	Y	Total	Total
Col1	SUM	SUM	SUM	AVG
A	10		10	10
B		20	20	20
C	30		30	30
D		40	40	40
Total	40	60	100	25

I have tried Dimensionality() and SecondaryDimensionality() but couldn't find proper solution.

Please help.

Thanks in advance,

Parag

[#2]

I Think of 2 possible solutions

(sum(x) +sum(y))/ (count(col1)+count(col2)) as total average

or

avg(

     Aggr(sum(x+y)

      ,

     Col1,col2

    )

)

Both expressions should calculate the total average