AVG in pivot table for some Values

[francisvandergr]

In my pivot table i wanna see for some values an avg in relation to the total for that period.

And some colours if the value is higher or below the avg over the total period for the same relative.

I have included an example for this question.

[sunny_talwar]

For part 1 you want to see the avg for just L and O or avg of A, B, C, L. I, O?

For part 2 can you re-explain please

Best,

Sunny

[francisvandergr]

Hi Sunny,

1. Indeed just for L and O but in relation to all.

For example month 1:

A       10 

B       20

C       30

L       40

O      100

I wanna see an avg after L from 20%   40   / 200

I wanna see an avg after O from 50%   100 / 200

[sunny_talwar · Accepted solution]

Is this the output you are hoping to see?

[francisvandergr]

Top thnx!