Let' say I have a pivotal table as follows in Qlik Cloud:
Where the fomula is the sum of each day * sum of the product during all the days, for the product 1 it would be = (2+3+4+5)*(2+6+2+2+0) = 168.
I have been looking around with no results, is such a thing even possibe?
The TOTAL keyword will solve your problem
Read below post
When should the Aggr() function NOT be used?
It's basically = Sum( TOTAL <Day> Expression) * SUM(TOTAL <Product> Expression)
Dear Vineeth thanks for your answer.
The problem I'm struggling with is adding the row in the design. Once I have the formular, how can I add a static row in the Pivotal Table where the value shown per day(Columns) is the one defined by the formula you've given me?
Here is how to add a custom row
Partial Sums in straight table | Custom Labels in Pivot SubTotals