Percentage Representativeness

[phaelcosta]

Hi guys,

I am new in Qliksense. Can you help me in this question?

I need to make a percentage representativeness, like a table below:

	Sales	% Repres.
Total	100	100%
Category 1	60	60%
Product A	40	67%
Product B	20	33%
Category 2	40	40%
Product C	30	75%
Product D	10	25%

The % of product is divided by category. In Qliksense I use the expression =SUM(Sales) / SUM(TOTAL(Sales)), but only category is correct, the products not.

What is the correct expression?

Regards,

[chrismarlow · Accepted solution]

Hi,

I am assuming you are using a pivot table, in which case I think you need to use Dimensionality, similar to below;

Cheers,

Chris.

[phaelcosta]

Thanks a lot. It's working.

God Blessed you