AVG pivot table

[carlos13]

I have the following table:

DATE	A	B	C	Total
31/12/2013	41.980.826.008	51.683.547.590	6.742.644.619	100.407.018.218
30/11/2013	42.488.250.790	51.951.483.509	7.322.630.578	101.762.364.877
31/10/2013	43.205.343.859	53.557.163.670	7.116.952.637	103.879.460.166
30/09/2013	44.241.516.622	52.011.540.832	8.792.556.502	105.045.613.956

I want have  a percentage column among  the total of the row. how is  calculation?

Any help is appreciated.

Thank you,

[carlos13]

A,B,C are a field called MODIF

[#3]

Hi Carlos

Is this what you need?

Lukasz

[#4 · Accepted solution]

Hi Carlos,

I understand that A, B and C are values from a Column_X and you are making a Sum of Colum_Value, if so, then you will have to use this:

Dimensions:

• Date
• Column_X

Expressions:

• Sum(Column_Value) / Sum(total<Column_X > Column_Value)

I hope it helps you

[#5]

Hi,

You can make A / Total if this column already exists

Or A / Rangesum(A,B,C) if it doesn't

[carlos13]

thank you very much

[#7]

I am glad it solved your problem.

Ryuma