Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
In my qlik sense pivot table, I got two rows:
The second row should be sales_amount/goal. So I put my function as: SUM(Amount)/Goal. The expression shows OK, but after applied, it becomes invalid dimension:
Is it because can't do calculation with dimension? What should I do if I still need to put Goal% into dimension?
Thanks in advance!
Try this,
AGGR(SUM(Amount), Customer) /Goal
Regards