Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Imagine a table with the sum of the expression below for each dimension of seglevel1 , sum all those numbers in the table that are positive for that value of seglevel1 , thats the total number i need please
Sum({< [Segment IS5_Description] ={'Headline Earnings'} >} ActZarYtd)
=Sum(Aggr(
IF(Sum({<[Segment IS5_Description] ={'Headline Earnings'}>} ActZarYtd)<0,
Sum({<[Segment IS5_Description] ={'Headline Earnings'}>} ActZarYtd),0)
,Segm_L1_Desc))
=Sum(Aggr(
IF(Sum({<[Segment IS5_Description] ={'Headline Earnings'}>} ActZarYtd)<0,
Sum({<[Segment IS5_Description] ={'Headline Earnings'}>} ActZarYtd),0)
,Segm_L1_Desc))