%age in pivot table

[musketeers]

Hi,

Need to calculate %age in pivot table. Consider this situation in excel (for example):

Sum of Quantity
Product_Info	Model_Info	Total
Product-1	Model-1	100
Model-2	150
Model-3	12
Model-4	70
Model-5	50
Model-6	200
Product-1 Total		582
Product-2	Model-1	450
Model-2	500
Model-3	230
Model-4	100
Model-5	90
Model-6	40
Product-2 Total		1410
Product-3	Model-1	34
Model-2	45
Model-3	23
Model-4	67
Model-5	500
Model-6	56
Product-3 Total		725
Grand Total	2717

Now for each Model in product I need to calculate percentage like for Model 1 in Product 1 the formula will be Total of Model 1 divided by Product-1 Total. ( 100/582) In the same way for other models.

Please guide me how we can do it in Qlikview.

Thanks

Rajneesh

[senarath]

Hi,

Hi you can select show Relative and get the percentage. So duplicate the same expression and modify it to show relative and check show values in data points,etc.

thanx

[MK_QSL]

Use below expression

SUM(Total)/SUM(TOTAL <Model_Info> Total)

or

SUM(Value)/SUM(TOTAL <Model_Info> Value)

[musketeers]

Hi,

Actually I need to do these things in pivot table. I am using AGGR function but it is not working also.

Thanks

[MK_QSL · Accepted solution]

Check enclosed file....