So I have an issue trying to use dimension totals in expressions. I basically want to calculate the % split between home and store for each "name" dimension. As you can see in "Named total" I get the correct total, but it will only show for one of the HD dimensions - this happens for all names, there is a total but it only populates either HD or STORE.
Using the total function in my aggr fills everything with the £4million total value, I want the £181k!
I need this to populate both fields so I can divide it by the value to get % split of Value in Agricultural (and subsequent dimensions).
Please help!