Skip to Content
0
Former Member
Jul 11, 2008 at 10:01 AM

Calculate percentages in query

240 Views

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.