Average - Department level Sum

[vikas_nandanwar]

Hi,

My data is as below -

Date	Dept	Total
1-Jan	A	100
1-Jan	B	90
1-Jan	C	500
2-Jan	A	110
2-Jan	B	70
2-Jan	C	480
3-Jan	A	150
3-Jan	B	50
3-Jan	C	580
4-Jan	A	120
4-Jan	B	60
4-Jan	C	510
5-Jan	A	180
5-Jan	B	50
5-Jan	C	550

Pivot -

Row Labels	Sum of Total
1-Jan	690
2-Jan	660
3-Jan	780
4-Jan	690
5-Jan	780
Grand Total	3600

I want Average of Total of Date in Grand Total

Answer = 720

please help

[vikas_nandanwar]

Hi Stefen,

I got the correct expression yesterday

Thanks anyways for the help.

Vikas

[Anil_Babu_Samineni]

Great, Please close this thread Qlik Community Tip: Marking Replies as Correct or Helpful

[vikas_nandanwar]

Hi,

I have a drill down in my data
Co., Sub Co.

When I use the expression -

=Avg( Aggr( Sum(Total), Date, Co., Sub Co.))

I do not get the desired output

[Anil_Babu_Samineni]

Please open new thread