Pivot Table add percentage close the count number for specific dimension

DMU1 — Fri, 09 Apr 2021 13:48:07 GMT

hi all,

I have a pivot table like this one:

	TEC	Tec1	Tec2	Tec3
REASON
Reason1		1	6	11
Reason2		2	7	12
Reason3		3	8	13
Reason4		4	9	14
Reason5		5	10	15

and I would like to obtaine a pivot table like this second one:

	TEC	Tec1	Tec2	Tec3
REASON
Reason1		1 (1%)	6 (6%)	11 (11%)
Reason2		2 (2%)	7 (7%)	12 (12%)
Reason3		3 (3%)	8 (8%)	13 (13%)
Reason4		4 (4%)	9 (9%)	14 (14%)
Reason5		5 (5%)	10 (10%)	15 (15%)

The numbers in the table are arbitrary not real

In my app I have two dimension: REASON and TEC

and the expression COUNT(Order_Number)

Could you suggest me a solution. I'm new in QlikView and I still have so much to learn!

I try this expression without the dimension reason for every distinct reason:

=round(Count({<Cancellation_Order_Reason_Detail={'CAUSA DI FORZA MAGGIORE'}>}Cancellation_Order_Reason_Detail)/Count({<Macro_Tec-={'LTE'}>}Order_Number),0.01)*100&'% ('&Count({<Macro_Tec-={'LTE'}>}Order_Number)&')'

It works, but in this way I lost the dynamic list of reason dimension. So I can't use this solution!

Can you suggest a solution without losing the dynamism of the REASON dimension list?

Thanks

topic Pivot Table add percentage close the count number for specific dimension in App Development

Pivot Table add percentage close the count number for specific dimension