i created a report using cube and excel. The report has 2 columns i.e. Date on the left and Term on the right. It has a measure which is Rate.
The report requires a row which store the average balance.
average balance = total daily rate / no. of days in the month
This average balance need to be displayed underneath the Grand Total in excel.
How can i display this row in the excel?
Another problem i'm facing is if the layout is not so restricted, i have problem calculating the average balance. i'm not sure how the mdx statement should be written.
i tried this statement but it gives me the wrong value:
avg([Date Tx].[month].Members,[Measures].[Mobile Rate]).
i tried using CurrentMember but i have syntax error.