Price comparison

[#1]

Hi everyone,

I'd lite to create a tab such as the attached one , the purpose is to compare prices differences between each 'depot' for each reference. If there's any difference i'd like to have a color marker somewhere in the tab.

Thing is, I don't know how the expression will look like.

So as dimension : Reference, Dépot

As expression  :  Prices.

If you got any idea, i'd be glad to discuss about it

Wish you all the best Christmas parties,

Southinho

[#2]

Load * inline [Reference, Depot, Value
1,111,1000
2,111,800
1,112, 1000
2, 112,800
3, 113, 400
3, 112, 300];

Demension: Reference, Depot

Expression: sum(Value)

Background colour (can be seen by pressing the + button beside the expression): if(sum(Value) <> sum( distinct total <Reference> Value), lightred())

[alkesh_sharma]

You can use colour mix wizard.

[Anonymous]

hi,

you can use below expression in background color:

if(sum(Value) <> sum( distinct total <Reference> Value), lightred(),lightgreen())

Regards

Neetha