Thanks, it works!
I also have another question. The % Omzet expression I have calculated with your help, this calculates the expression for each firm (dimension) in the column seperately. I Also have calculated an expression which calculates the % for all firms, no matter what firm is selected or what firm is shown in dimension (% Totale groep = +Sum( TOTAL <RESULTAAT> {<Firma={"*"}>} Maandcijfer)/SUM(total{<Firma={"*"},RESULTAAT = {'verkopen z btw'}>}Maandcijfer)).
This also works, so for each firm I get the relative figures against sales (verkopen z btw) in column "% Omzet", and in column "% Totale groep" I get the relative figures for the whole group of firms, so I can compare one firm with the average. Now the problem is that when I select 1 firm (firm A hereunder is selected), Firm B is also shown because the expression "% Totale groep" is always active. In what way I can tackle this?
Thanks in advance
| Firma | Totaal | Totaal | Totaal | Firm A | Firm A | Firm A | Firm B | Firm B | Firm B |
| RESULTAAT | Saldo | % Omzet | % Totale groep | Saldo | % Omzet | % Totale groep | Saldo | % Omzet | % Totale groep |
| verkopen z btw | 3 884 903,76 | 100% | 100% | 3 884 903,76 | 100% | 100% | 0,00 | - | 100% |
| kostprijs der verkopen | -3 039 729,20 | -78% | -78% | -3 039 729,20 | -78% | -78% | 0,00 | - | -78% |
| BRUTOWINST | 845 174,56 | 22% | 22% | 845 174,56 | 22% | 22% | 0,00 | - | 22% |
| diverse opbrengsten xxx | 57 421,77 | 1% | 1% | 57 421,77 | 1% | 1% | 0,00 | - | 1% |
| mali/prijsverlagingen/kaart | 5 185,24 | 0% | -1% | 5 185,24 | 0% | -1% | 0,00 | - | -1% |
