Hi,
I have a detailed sheet which contains complex formulas based on the details in this sheet.
The user wants to create pivots of this data in Qliksense, but when the formula is applied at the summary level then the totals are different.
What I want to do is save the convert the field in my detailed report into a value, so that I can then sum this value field in my pivot rather than trying to re-calculate using a formula.
