Calculate measure with measure name from Excel template
i would like to make P&L app in the Qlik sense Feb 2019. According to below excel template, in pivot table,
row is from header text and column from measure. eg. in table, if the header text is GS, get measure name is Gross Sales amount, in the database there is field called Gross Sales.
it can accomplish with several if statement, however i would like to make it automatically ways. if user want to add one row in existing table like want to see profit, he just put header text and measure name in the excel template and load data. Thanks in advance, experts.