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

On 14 יולי, 14:18, "eya... (AT) gmail (DOT) com" <eya... (AT) gmail (DOT) com> wrote:
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';