# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## logic

I have this type of data

 ADS PN GE 751-715 10%  to IE ADS PN AE 751-716 10% IE

above tables shows that 10 % goes to IE and other goes to GE

and in second row 10% go to IE and other 90% go to AE i.e. we must total to 100% not above 100

now here in below that how i distributed % according to above table to make 100% because above table shows that 90% to AE 90% TO GE and 10 % to IE  this because around 190 but i want to make this 100 how i do this or is there any formula we apply to make total 100 %

AND THIS ANOTHER SHEET

Tags (2)
2 Replies
Esteemed Contributor

## Re: logic

Hi,

how do you calculate the % ? do you calculate it on the script or on the chart ?

New Contributor III

## Re: logic

% here is given by customer.. and not necessary this is 10% this is may 20% to IE and remaining % to GE