i am trying to create a stacked bar chat in Qlik Sense.
i am taking Month and Product as a dimensions
and sum(ActualValue)/ sum( TOTAL <MONTH> PlannedValue) as Measure.
how to make it 100 % ???
it is giving me 82.9 , 85.2 and so on..i want to make it 100 %
Your help would be highly appreciated.