Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you try like,
Sum(sales) /sum(total sales)
Or try using dimentionality
Can you try like,
Sum(sales) /sum(total sales)
Or try using dimentionality
Thank you Anat, didn’t know the total function. All sorted.
can you please mark this one as accepted solution, it will be useful for others also.