PIVOT TABLE SHOW ISSUE

[#1]

I have a pivot table with State as a dimension .  If you  see the attachment NO_Month_Selection. I can see Sates 'AR'  and  'KY' which is what I would like to see, but as soon as I select the month 'Jan'  (attachment MOnth_Selection), I loose 'AR' and 'KY'.  What do I need to do so that I should see 'AR'  and 'KY'.

Here is my expression

If((sum({<Year={$(=MAx(Year))},NO_BOP_FLAG={'0'},ORGANIZATION_NAME= ,[Line of Business]=>}INDEMNITY_PAID_YTD-INDEMNITY_RECOVERY_YTD)

or

sum({<Year={$(=MAx(Year)-1)},NO_BOP_FLAG={'0'},ORGANIZATION_NAME= ,[Line of Business]=>}INDEMNITY_PAID_YTD-INDEMNITY_RECOVERY_YTD))='0',0,

((max({<Year={$(=Max(Year))} ,NO_BOP_FLAG={'0'},ORGANIZATION_NAME= ,[Line of Business]=,Month = {"<=$(=Max(Month))"}>}MthNbr)/12)

*Sum({<Year={$(=Max(Year))},NO_BOP_FLAG={'0'},ORGANIZATION_NAME= ,[Line of Business]=,Month = {"<=$(=Max(Month))"}>} ind_budget)))

[HirisH_V7]

Hi,

Check once in your data For JAN in the States 'AR' and 'KY'. Data is there or not??

I Think your data is picking some Null Date Month Data when your are not selecting Months.

[#3]

NO there is no data for 'AR' and 'TN' for 01/2016.  but I still wanna display AR and TN.  Here is the issue The column I am shoing is the budget , I do have budget for 01/2016 but the actuals for 01/2016 are 0/ So I want to list 'AR' and 'KY' budget even though the actuals are '0'

[#4]

but thats what I want to see

[HirisH_V7]

Hi,

Check Show null values for your Dimension!!

[#6]

Attached is the desired result.

[HirisH_V7]

Hi,

What expressions you are using for,

2015 and 2016 columns displayed,

[#8]

fOR 2016, EXPRESSION IS

sum({<Year={$(=MAx(Year))},NO_BOP_FLAG={'0'},ORGANIZATION_NAME= ,[Line of Business]=>}INDEMNITY_PAID_YTD-INDEMNITY_RECOVERY_YTD)

For 2015 Expression is

sum({<Year={$(=MAx(Year)-1)},NO_BOP_FLAG={'0'},ORGANIZATION_NAME= ,[Line of Business]=>}INDEMNITY_PAID_YTD-INDEMNITY_RECOVERY_YTD)

[HirisH_V7]

Hi,

sum({<Year={$(=MAx(Year))},NO_BOP_FLAG={'0'},ORGANIZATION_NAME= ,[Line of Business]=,Month=>}INDEMNITY_PAID_YTD-INDEMNITY_RECOVERY_YTD)

sum({<Year={$(=MAx(Year)-1)},NO_BOP_FLAG={'0'},ORGANIZATION_NAME= ,[Line of Business]=,Month=>}INDEMNITY_PAID_YTD-INDEMNITY_RECOVERY_YTD)

Check now