set analysis pivot table column presentation

[felcar2013]

hi,

i want to represent the last column "additional sales" like it is showed in the table. A rest of sales per custumer (target-control), in case there is no control, then it shall be "0". Same for the Target row with no control for the Variant.

test data attached

felipe

[settu_periasamy]

May be try

=[sales per customer]-Above([sales per customer])

[ecolomer]

Is this?

[felcar2013]

perfecto, gracias

[ecolomer]

Marca, por favor, la respuesta correcta y cierras el hilo.

Gracias.

Saludos,

Enrique Colomer