Average Calculations

[tmumaw]

Hi all,

I need to be able to calculate averages at different levels using one QVD.  I need averages for WKNO, FISPD, QTR and FISYR for each profit center.  Any ideas?

Thanks

[sunny_talwar]

Average of EmpCt_ZEMPCT? May be with cycle group and Profit Center as dimension and Avg(EmpCt_ZEMPCT) as expression?

[tmumaw]

Yes average of EmpCt_ZEMPCT

[tmumaw]

Sunny do you have an example

Thanks

[qlikview979]

Not sure,

are you expecting like this

[tmumaw]

Yea something like that....can you  attach the model please

[qlikview979]

Hi ,

PFA

[tmumaw]

Mahesh,

I think you misunderstood me.  I need to know the average number of employees by FISYR, QTR, FISPD and WKNO, Not the averages of the time dims.

Thanks

[tmumaw]

How can I get a sum of all the averages......

[qlikview979]

Hi Are you  expecting like this

avg(WKNO+FISPD+FISYR+QTR+EmpCt_ZEMPCT)