I am working with a cube and have my date hierarchy as Year - Quarter - Month - Day. I need to be able to get Average Daily Charges. For example, for January, I need sales/31 days, however, if we're in May on the 19th, I need the charges/current day number. Thanks.