topic Re: pivot table presentation in QlikView

set analysis pivot table column presentation

felcar2013 — Wed, 13 Apr 2016 15:41:31 GMT

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

Re: pivot table presentation

settu_periasamy — Wed, 13 Apr 2016 17:19:04 GMT

May be try

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

Re: pivot table presentation

ecolomer — Wed, 13 Apr 2016 18:05:08 GMT

Is this?

Re: set analysis pivot table column presentation

felcar2013 — Thu, 14 Apr 2016 13:47:25 GMT

perfecto, gracias

Re: set analysis pivot table column presentation

ecolomer — Thu, 14 Apr 2016 13:54:33 GMT

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

Gracias.

Saludos,

Enrique Colomer