Pivot Table expression

[tomcatxx]

Hi, there. I want to make a pivot table like that. There are only 2 dimensions 'Minifabrik' and 'Day'.

Minifabrik	Day	We	Th	Fr	Avg	Target
MF1		%	%	%	%	%
MF2		%	%	%	%	%
MF3		%	%	%	%	%
MF4		%	%	%	%	%

I made a table but not finished.

Values for column We Th and Fr are  Sum(A)/Sum(B).

Can u help me to write expression for column Avgerage and Target?  Target = avg(T)

Thank you.

data source

Load  Minifabrik,

          Day,

          A,

          B,

          T

From xx.qvd

[neelamsaroha157]

You can use pick and match to get the one column for the avg and target instead of repeating it for everyday. And as Sunny said, it would be easier to understand once you provide the sample data.

[tomcatxx]

Oh, I'm sorry. It's here.  Pivot Avg() .Help!

[tomcatxx]

Thank you. It's a test. Pivot Avg() .Help!