Pivot table Expression

[#1]

Hi all,

The below Condition is Applying in my   Pivot Table  for The Expression volume ;

Correct Results are showing while Individual Selections on Dimensions.wise like material ,material Group Etc..while clearing the Selections ..the Below Condition is not Working..

if(GROUP = ('2A')  and  PERID < 201408 ,aggr(Sum(CONS_FKIMG), PERID, GROUP),

if(GROUP  = ('3A') and PERID < 201408 ,aggr(Sum(CONS_FKIMG) , PERID, GROUP),

Sum(PLAN_FKIMG)))

CONS_FKIMG------is a key figure Which is Coming From another Data set if the above condition is Success

PLAN_FKIMG------ condition fails values populating from  Pivot table source dataset...

Thnaks

[tyagishaila]

Can you attach you qvw file, to understand more clearly the problem which you are facing.