I am facing typical scenario, I want guru's advice,


Here is my problem,

I have cube with measure named MILE, user can browse cube with month
dimension,

In a month, This miles can be divided into

three category

Chargeable Accident
Non-Chargeable Accident
Unknown Accident

Sum of above three equal to Total Miles for that month.

I have calculated member, that required Total Miles irrespective of category,
this calculated member required total miles,


Is there anyway to calculate total miles in a month stored in a cell make
this cell hide and
To use it in calculated member formula.


Thanks
Kal