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

[niclaz79]

Avg(RangeSum(Before(Sum(A)/Sum(B),0,7)) maybe?

[suhaskharat]

Use below formula for average

Column(1)+Column(2)+Column(3)/3

for target as u have mentioned

(Column(1)+Column(2)+Column(3)/3)/100

[tomcatxx]

Thank u, but it doesn't work.

[tomcatxx]

Can u you write Expression for that?  And sometimes I have data for 7 days(Mo~So). In this table, the null value just will not be showed.

[niclaz79]

Ok, try the following

Avg(Sum(TOTAL <MF> A)/Sum(TOTAL <MF> B))

[sunny_talwar]

Would you be able to share some raw data or a sample app?

[tomcatxx]

Yes, I made a test.

[balabhaskarqlik]

May be like this:

=Sum(Sales) / Count(DISTINCT Date)

[sunny_talwar]

Where is the test file? can you share it with us?