Set Expression

[upaliwije]

I have attached my QV document where you find two pivot tables in my below shown table I want to show  under the column "premium renewed rating to other month"  premium renewed that do not fall into current month.

I want to show Rs.19728 in last column that this the amount relating to 1st policy no highlighted in yellow where pol period to ens in April but not in may . Pls help me

[upaliwije]

Hi Friends

Pls help me with solution for my problem

[upaliwije]

My Friends

Any feedback to my above discussion is welcome

[Anil_Babu_Samineni]

Like this?

I am considering as Month(POL_PERIOD_FROM) = Month(POL_PERIOD_TO) with in the set analysis

[upaliwije]

Thanks Anil,

Could you please attached the modified QV Document

[upaliwije]

If I modify the expression as you said it does not work

Below is my new set expression

sum( {<R_YEAR=,R_MONTH=,[R_MONTH] = {$(=concat([R_MONTH],','))},[R_YEAR] = {$(=max([R_YEAR]+1))}, Month(POL_PERIOD_FROM) = Month(POL_PERIOD_TO) ,POL_TYPE={'R'}>} [PREMIUM] )