% of total when using show all values

[adamdavi3s]

Hi All,

I'm flummoxed with this one....

I am trying to create a table to show details for all 'TRUSTS' regardless of what TRUST is selected.

• Note that in this situation there will always be one selection in the field HRG_DESCRIPTION
• Note the actual selection in TRUST is currently 5 different values

To ensure all values are displayed I have checked the 'Show All Values' on the dimension, my trick now is getting the formula correct!

As you can see, the first one is fine, however for some reason the second displays only for one TRUST (Note dimension values blanked)

Column Activity code:

SUM ({< TRUST -= >}[FCE NUMBER])

Column %Activity code

SUM ({<TRUST -= >}[FCE NUMBER])/
AGGR(SUM({<TRUST -= >} [FCE NUMBER]),HRG_DESCRIPTION)