unable to execute set analysis date wise

[#1]

Dear All,

facing problem of using set analysis

we are created variables as below

CCR_PPC : 

=sum( { $ <Plant_Code= {'2300'}, Product_Type={1}, Material_Code={'CCRPPC'},  VC.Period=P(VC.Period) >} Quantity )

CCR_PSC :

=sum( { $ <Plant_Code= {'2300'}, Product_Type={1}, Material_Code={'CCRPSC'},  VC.Period=P(VC.Period) >} Quantity )

When we are using above result in pivot table with expression as below

if(match(PCSNO,7,8,9)<>0 and Plant_Code=2300,if(Material_Code_Product='PPC',CCR_PPC,if(Material_Code_Product='PSC',CCR_PSC,0)))

then its giving result value of the month not day wise.

[tajmohamed30]

You can use Day(Date_Column) in your expression

[Peter_Cammaert]

I guess your variable formulas are being calculated at the wrong moment. Maybe you should remove the equal signs from your variable formulas, and use $-sign expansion in your actual expression. Like:

CCR_PPC :

sum( { $ <Plant_Code= {'2300'}, Product_Type={1}, Material_Code={'CCRPPC'},  VC.Period=P(VC.Period) >} Quantity )

CCR_PSC :

sum( { $ <Plant_Code= {'2300'}, Product_Type={1}, Material_Code={'CCRPSC'},  VC.Period=P(VC.Period) >} Quantity )

Pivot table formula:

if( match(PCSNO,7,8,9)<>0 and Plant_Code=2300,

   if(Material_Code_Product='PPC', $(CCR_PPC), if (Material_Code_Product='PSC', $(CCR_PSC), 0)))

Best,

Peter

[#4]

Dear All,

Thanks for your response

There was some other problem in my pivot table dimensions. the same has corrected now.

Please ignore the discussion.