Hi gurus,
Me and my team are working in creating queries in BI, I have some trouble calculating some porcentge.
I want to create calculated KF that shows the following situation:
Revenue Percentage of total
Material A: 10$ 33%
Material B: 20$ 66%
Total: 30$ 100%
As you see, I want the KF to display in the query, in every material line, the percentage of the total revenue. Do you know how to calculate this percentage?
Thank you very much in advance.