Cumulate having multiple Dimension in Pivot

Sun, 21 May 2017 14:48:10 GMT

Hello

I have a pivot table with multiple dimension, and I am trying to cumulate the values based on the logistic Type (header) as shown below

LAB	LeadTime	LogisticOrderType	Invoice Date	05/03/2017
MTCS	A	AV		4	4	11%
MTCS	A	CD		-
MTCS	A	AP		-
MTCS	B	AV		24	28	80%
MTCS	B	RR		1
MTCS	B	FF		4
MTCS	B	CF		-
MTCS	B	CD		295
MTCS	B	AP		6
MTCS	C	AV		7	35	100%
MTCS	C	RR		2
MTCS	C	FF		-
MTCS	C	CF		-
MTCS	C	CD		736
MTCS	C	AP		63

for eg, AV in Logistic type repeats for A, B, C I want to add 4 to 24 for B and 7 to 28

AV has to cumulate to 100% in C

Please help I have attached a file as well

Re: Cumulate having multiple Dimension in Pivot

ahaahaaha — Mon, 22 May 2017 08:41:49 GMT

Hi,

May be as variant in attached file. I especially did not delete the intermediate expressions (made them hidden in the settings), so that the computational logic was understandable.

Regards,

Andrey

topic Re: Cumulate having multiple Dimension in Pivot in QlikView

Cumulate having multiple Dimension in Pivot

Re: Cumulate having multiple Dimension in Pivot