Pivot Calculation Problem

[Anil_Babu_Samineni]

Dear Friends,

Why this pivot table getting problem

Please check the calculation? Sum. Left of everything is working but this is not working

Correct Value is - 30, But here showing 29.

Can i know what is modification i required

[Anil_Babu_Samineni]

Max,

For Month it is working fine with this expression

=sum({<C_DESCRIPTION={'Reportable','Recordable','Restricted work Cases','Lost Work Cases'},P_Des-={'All Plants'} >} DISTINCT S_COUNT)

But, YTD calculation is not working, Can you please help me here.

=sum({<Year={'*'},Month={'*'},C_DESCRIPTION={'Reportable','Recordable','Restricted work Cases','Lost Work Cases'},P_Des-={'All Plants'}>} distinct S_COUNT)

I want to explain, One thing, For above expression if i change Year or Month YTD values are constant. Help me please

Year & Month Fields

year(S_CREATED_DATE) as Year

num(Month(S_CREATED_DATE)) as Month

I don't know why this value is not changed