Using 'Total <Dimension>' in a Pivot Table in Qlik Sense
I am trying to use the total keyword in a pivot table, and am getting strange results. I am using a fact table structure similar to the following:
.. and so on. The reason the Salaries are included in the fact table is that these values are attached to a particular payslip, and can change over time. The sales are not recorded against any particular employee, just against the store.
What I am trying to achieve is to display the sum of sales for that store, against each employee in a pivot table. The values are displayed correctly against the store, until a node is expanded, where each value is then turned to 0:
What I am trying to achieve is the Sum figure of $437,227.12 is displayed in this column for Adam, Bob and Steve.