Table Help

[Anonymous]

Hello,

I ran into a curious issue, and looking for the best way to handle.  I created a pivot table, that allows to show by year and % basis.  When I do not select a year, the table shows about 1/2 the true percentage.  When I select one of the years, it returns the proper amount.  Picture below:

Here is my expression:

Sum ({<[CAT IND]={'N'},  [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [LINE OF BUSINESS]={'HOME'}, [MONTH-TEXT]=, [CLAIM SYM GROUP SMG]=-{'N/A'}, [DATA ORIGIN]={'SMG BY COV'}>}[AY INCURRED W ALAE])

/Sum ({< [CAT IND]={'N'},  [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [LINE OF BUSINESS]={'HOME'}, [CLAIM SYM GROUP SMG]={'BLANK'} , [MONTH-TEXT]=, [DATA ORIGIN]={'SMG BY COV'}>} total [DIRECT EARNED PREMIUM])

Looking for some thoughts to the best way to show the percentage properly over the two years.

Thanks for the help,

Justin

[stigchel · Accepted solution]

Can you try with

Sum ({<[CAT IND]={'N'},  [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [LINE OF BUSINESS]={'HOME'}, [MONTH-TEXT]=, [CLAIM SYM GROUP SMG]=-{'N/A'}, [DATA ORIGIN]={'SMG BY COV'}>}[AY INCURRED W ALAE])

/Sum ({< [CAT IND]={'N'},  [MONTH-NUMERIC] = {"<=$(=max({<YEAR={$(vBusinessYear)}>} [MONTH-NUMERIC]))"}, [LINE OF BUSINESS]={'HOME'}, [CLAIM SYM GROUP SMG]={'BLANK'} , [MONTH-TEXT]=, [DATA ORIGIN]={'SMG BY COV'}>} total <Year> [DIRECT EARNED PREMIUM])

[swuehl]

Try

.... total<Year> [DIRECT EARNED PREMIUM])

[Anonymous]

Perfect, thank you for the help!

Justin