I am trying to calculate % based on subtotals in pivot table in Qliksense

[vineetadahiya12]

  In pivot table I will have Country , State  Line Amt. I need to show the % using subtotal values in qliksense

Country	State	Line Amt	%
India	Delhi	30	30% (  (30/100)*100
	Punjab	40	40%
	Haryana	30	30%
US	LA	25	25%
	CA	25	25%
	New York	50	50%
Total		200	--

I am looking something similar to  Line Amt / Sum(Line Amt) Group By Country.

[sunny_talwar]

Try this:

Sum([Line Amt])/Sum(TOTAL <Country> [Line Amt])

[Varsha]

I have a requirement to find percentage of subtotals.
Like in above example, I want to get sum(line amt)/ sum (line amount for all the countries),
((total for India)/(total for India and US))*100