How to color code only the difference in a pivot table?

[nenadvukovic]

Hi,

Can anyone please take a look and help me get what I want?

It's about marking in different colour only cells that differ from the cell above.

[fvelascog72]

Hi,

Try this in Color Text in Expression:

=if(Above(TOTAL sum(Exp1), 1,1) <> Sum(Exp1) and not IsNull(Above(TOTAL sum(Exp1), 1,1)) , lightred())

Saludos

[nenadvukovic]

Hola Federico,

That is better but still not good enough if it is applied to a more realistic data than initially provided:

Gracias

[fvelascog72]

Hi,

Could you share this dataset?

Saludos.

[nenadvukovic]

Test:

load * inline [

Dim1, Dim2, Dim3, Dim4, Exp1, Exp2

A, C1, D1, E1, 30, 1459

A, C2, D1, E1, 30, 1459

A, C1, D2, E1, 40, 1953

A, C2, D2, E1, 40, 1953

A, C1, D2, E2, 43, 2094

A, C2, D2, E2, 43, 2094

A, C1, D2, E3, 50, 2444

A, C2, D2, E3, 90, 4399

A, C1, D3, E1, 20, 1005

A, C2, D3, E1, 20, 1005

];

[fvelascog72 · Accepted solution]

Hi,

I tried with:

=if(Above(TOTAL sum(Exp1), 1,1) <> Sum(Exp1) and not IsNull(Above(TOTAL sum(Exp1), 1,1)) and not IsNull(Above(Dimensionality())), lightred())

and seeem to work.

Saludos.

[nenadvukovic]

Indeed.

Thank you very much

[fvelascog72]

You´re welcome