If I sum up e.g. sales (see attached file) how I can multiplicate 2.5% of total sales and add it to purchase, so that my table will look like this excel screenshot?
Thanks for any tips.
4 answers
Hi, Patrick
Please find my solution attached, below is the screenshot of result
This solution you don't need union your data, but if you need display the highlighted part in the view as well, I think you need Yuriy's solution of union your data
Hope this helps
ZZ
