Partial average.

[#1]

Hello all, I am lee.

• I want to have partial average instead of partial sums    in example format.

I attached example.

please let me know.

Thank you so much

[#2]

Im lee

Example here

[SunilChauhan]

use expression as

sum(TAT)/Count(distinct TAT)

or

sum(TAT)/Count(TAT)

hope this helps

[JonnyPoole]

I divided by the number of FABOUT_TM (top screenshot)  and combination of FABOUT_TM and STAT_AREA (below screenshot)

Above:   sum(TAT)/ count( DISTINCT FABOUT_TM)    ...partial row averages and column totals

Below:  sum(TAT)/ count( DISTINCT FABOUT_TM&STAT_AREA)   ...partial row averages  and column averages

[#5]

could you give me . example qvw. file  please~

[JonnyPoole]

here is the qvw

[SunilChauhan]

see the modified qvw attached by you

[#8]

Thank you Poole~

but how FABOUT_TM is same and different LOT?

isn't it Wrong using DISTINCT function?

[sujeetsingh]

There are two things:

Straight table provide options to define a expression for total

Pivot table do not provide such option hence if you are having average in your expression the pivot total will use the same expression to calculate the totals.

[SunilChauhan]

distinct will take single ocuurance  of partiuar

where as if you want to count all

use Count(FABOUT_TM )