Date in set Expression

[upaliwije]

Hi Friends

sum( {$<[R_YEAR] = {'$(=max([R_YEAR]))'},[R_MONTH]-={'$(=max([To_MONTH]))'},POL_TYPE={'F'}>} [PREMIUM] )

I have written the above expression in the attached file and it is working, But I want to modify it to show foolowing

When the use select R_Year as 2013 and R_Month as Jan

I want to show only  records where To_Month<> R_Month (when R_Month=Jan then To_month= any month other than Jan)

In other words 1st 11 records shown in my my pivot table(attached) should be excluded and all other records must remain as it is

Please help me to rewrite the  expression

Thanks

• 000001.qvw

[Gysbert_Wassenaar · Accepted solution]

This should do it: sum( {$<[To_MONTH]-={'$(=only([R_MONTH]))'},POL_TYPE={'F'}>} [PREMIUM] )

[israrkhan]

Hi Gysbert,

can you please comment on this post.

Pivot Table Rows.

would be much appreciated...

Thanks...

[upaliwije]

Thanks a lot