Hello
I have a percentage problem.
I have a store dimension (Profile - Subprofile - Store)
and a time dimension (YQM). In my virtual cube I would
like to have one measures percent (called Keyvalue) of
another measure. Fine, A/B*100...
but...
for some stores I have one measure but not the other
(which makes it A/null*100 or null/B*100). The Keyvalue
gets an ERR for that store, and that is great. But on the
TOTAL (and the totals for each level in the dimension
Store) the Keyvalue is wrong:
A B Keyvalue
Store1 12 120 10%
Store2 26 - Err
Store3 20 80 25%
Store4 60 100 60%
TOTAL 118 300 39,3%
I dont want the TOTAL to include the Store2's A-value. I
would like it to be (12+20+60)/(120+80+100)*100=30,7%
Jesper