Percentage calculation

[dries_clairhout]

Hello,

Here's the situation:

I have a calculation: sum(colli) and sum(losseStuks) these to combined shows a total.

Now I need to show how much percent of this total contains colli and how much contains losseStuks.

So sum(colli) + sum(losseStuks) = 100%

colli = ..% of this total

losseStuks= ..% of this total

this should all be in a pivot table.

Where the dimension is a name and the measure is the percentages.

any ideas?

This is way to difficult for me.

Thanks in advance

DC

[Zhandos_Shotan · Accepted solution]

Hi!
May be this?:
mes1:
sum(colli) / ( sum(colli) + sum(losseStuks) )
mes2:
sum(losseStuks) / ( sum(colli) + sum(losseStuks) )

[dries_clairhout]

Fantastic,

didn't know it could be this simple!

Thanks a lot.