Pivot table % Total

[Ah84]

maybe a simple solution but I’m relatively new to Qlik. I’m trying to replicate excel pivot table functionality, specifically the % of grand total, but the aggregations options are not present for this. Is there a expression I can use? I have selected the ‘show totals’  option, so now I want the same measure field but with each row as % of grand total.

thanks in advance 

Al

[anat · Accepted solution]

Can you try like, 

Sum(sales) /sum(total sales) 

Or try using dimentionality 

[Ah84]

Thank you Anat, didn’t know the total function. All sorted.

[anat]

can you please mark this one as accepted solution, it will be useful for others also.