Change formula in Table based on selection?

[Douwe_KB]

Hi there,

I currently have an overview table of customer IDs and their sales for every possible Product Group that we offer. If I select a single customer the following calculation works perfectly and shows the correct percentages, see example below:

However, when I include all other customer IDs the percentages change.. Instead of using the "Omzet" (Sales) total PER customer ID. It now takes the total of sales: 

The correct percentage for "Boter" should be 62.39%, but it now shows 0.45%.

This is the formula I am now using in my table to calculate "Daadwerkelijk percentage".

Sum({<CProductgroep>} Omzet)/Sum( TOTAL {<Klantnaam>} Omzet)

Where Omzet is Sales.

Any help is appreciated. Thanks!

[MayilVahanan]

Hi

Try like below

Sum({<CProductgroep>} Omzet)/Sum( TOTAL<Klantnaam> Omzet)