Hi, there. I have a question about pivot table. I need a pivot table like that.
But I don't know how to write expression to get the last 2 columns. I made a test .qvw for u. Avg is average % value of days for MF. Target is a field which u can find in loaded table.
Help! Thank you very much.
There are many ways of doing it a simple can be with adding a dummy dimension and using the below expression
Dim1 : ' '
Dim2 : Region
Exp : If ( isnull(columnno()) , Give your target expression here ,
Avegrage expression here )
Probably you need to share excel, That would spot. But, Here is the lucky way
Load * Inline [
2) Pick(Dim, 'Avg', 'Target')
Pick(Dim, (Sum(A)/Sum(B)), (Avg(A)/Avg(B)), ((Sum(TOTAL A)/Sum(TOTAL B))/(Count(TOTAL <A> A)/Count(TOTAL <B> B))))
Thank you for ur post. But it looks like that. There is only average values.
What I want is like that, in which u can see all values. You don't need Excel because u can find it in qvw.