I would like to convert the Delivery Costs/Sales row into a new column in the pivot table below so the percentage value is displayed right next to the delivery costs value. It could be even in the same cell as the delivery costs value. For instance, it would show R$ 150,00 (1,24%).
The Sales and DeliveryCosts come from different tables and both are associated to another table through ClientID.
It seems both options are easily doable, but I am unable to solve it. I wouldappreaciate any help!
I have tried all possible drag and drop combinations without success so far.
The Delivery Costs/Sales value was created through a chart function.
I'm not sure how to implement the second option you suggested. Ideally, I would make this calculation in my excel files and just choose to show them in my pivot table as a new column. But the two values needed for the calculation come from different workbooks. I thought it would be easier to do it on Qlik Sense, but my knowledge is limited.