var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How do I create a YTD Cost calc member or calc cells?
How do I get the YTD AdCost column shown on the right in the sample output from my Project cube?
2000_____2005 2005-Q1_2005-01 8,795,243.85______8,795,243.85
________________2005-Q3 2005-07 38,666,890
________________2005-Q4 2005-10 13,517,000
1) I need a YTD colum that sums AdCost from the same year.
I have other members in the source dimension table including month (01,02,...).
I'd like to allow users to use this column in the cube spreadsheet.
2) Not sure whether to use a calc member (seems easier to write) or calculated cell.
Note that this is a home-grown time dimension not from AS2k.