Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all, I am lee.
I attached example.
please let me know.
Thank you so much
Im lee
Example here
use expression as
sum(TAT)/Count(distinct TAT)
or
sum(TAT)/Count(TAT)
hope this helps
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
could you give me . example qvw. file please~
here is the qvw
see the modified qvw attached by you
Thank you Poole~
but how FABOUT_TM is same and different LOT?
isn't it Wrong using DISTINCT function?
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.
distinct will take single ocuurance of partiuar
where as if you want to count all
use Count(FABOUT_TM )