GRAND TOTAL IS EMPTY

[e***@gmail.com]

Hi All

I have a calculated member that shows the data
but the grand total IS EMPTY :
YEAR MONTH Sale Value - Fact Pidion Daily CurrentSSSPidion
ParallelSSSPidion
2011 032011 4,778,665 3,513,215.97
3,381,990.79
Total 4,778,665 3,513,215.97
6,284,412.85
Grand Total 4,778,665 3,513,215.97

can somebody assist

[e***@gmail.com]

Post by e***@gmail.com
Hi All
I have a calculated member that shows the data
YEAR    MONTH   Sale Value - Fact Pidion Daily  CurrentSSSPidion
ParallelSSSPidion
2011    032011  4,778,665                                       3,513,215.97
3,381,990.79
        Total   4,778,665                                       3,513,215.97
6,284,412.85
Grand Total     4,778,665                                       3,513,215.97
can somebody assist

HERE IS THE MDX :

CREATE MEMBER CURRENTCUBE.[Measures].[ParallelSSSPidion] As
IIF (ISEMPTY(([Measures].[Sale Value - Fact Pidion Daily],[Dim SSS].
[SSS YN].&[1]))
,NULL
,-- ELSE
SUM((ParallelPeriod([Dim Time].[Monthly].[Year],1, [Dim Time].
[Monthly].CURRENTMEMBER)),([Measures].[Sale Value - Fact Pidion
Daily]))
) -- END IF
, FORMAT_STRING = "#,##0.00;-#,##0.00"
, VISIBLE = 1, ASSOCIATED_MEASURE_GROUP = 'Fact Pidion Daily';