I'm creating a profit and loss Qlik Sense app and want to include percentages as a measure within a straight table. The percentage is calculated as the sum of values for the particular line divided by the sum of values for another line. E.g. The following is how I want the table to be, with the Percent column being a measure.
Cost of Sales
For each line I know via a dimension that the row to divide by is 'Sales', e.g. PercentReference in the following
Load * Inline [
LineDescription, Value, PercentReference
Cost of Sales,70,Sales
I want to add a measure for the % along the lines of