Pivot Average, ignore dimensions.

[#1]

Hi,

I have a pivot table with average process times per monthday (1-31), dimension STARTTIME_DAY. I want one additional column to display the daily average over the whole set.

Daily average is computed as follows:

=time(avg(STARTTIME-ENDTIME))

I have tried

=time(avg({<STARTTIME_DAY=>}STARTTIME-ENDTIME))

but this will return an additional column for each day, while I want a column similar to partial sum.

Any ideas will be appreciated.

[sujeetsingh]

Plz provide a sample,

[#3]

Hey,

unfortunately I can't share the Qlikview file but here's an example of what I want in Excel.

Stupid, in the total column Qlikview automatically computes the expression over the complete dimension.