Getting all values are null() in Pivot table

[vidhya91gct]

Hi All,

I am facing issue on pivot table, I am using master calendar and master calendar joined by using using autonumberhash(Proj_ID,Yearmonth and Date)with my table...while adding date field in master calendar ,it getting all values are null in pivot table as below.

MasterCalendar:

Pivot Table:

Used columns:

Expected Output:

Need to show oly corresponding baselinegatevalue with month,

Please help me on this issue.

Thanks,

Vidhya k

[ogautier62]

Hi,

I didn't understand your data model and your graph :

it should work with baselineMonth in dimension,

what is your expression ?

regards

[vidhya91gct]

Hi,

Please find the below expression ,

=if(BaselineMonth=YearMonth and Baseline=TDate,BaselineGateVal,'NA')

Thanks,

Vidhya K

[ogautier62]

you must put an agregation function in your expression, that's why it's null

only or maxstring for example

[vidhya91gct]

Hi ,

For example,

I have selected 2016 in year and i m getting Baseline month is 07-2016 and BaselineGateVal is null() and SOE.

I want to show SOE for the corresponding month as below,

Thanks,

Vidhya K

[ogautier62]

you have two values for BaseLineGateVal : SOE and blank

try this maybe :

if(BaselineMonth=YearMonth and Baseline=TDate and not(isnull(BaselineGateVal)),BaselineGateVal,'NA')

[vidhya91gct]

Hi,

Thanks for your suggestion,

Already i tried this expression,but it is not working and getting 'NA'only.

if(BaselineMonth=YearMonth and Baseline=TDate and not(isnull(BaselineGateVal)),BaselineGateVal,'NA')

[ogautier62]

not(isnull(trim(BaselineGateVal)))

to remove blank

[vidhya91gct]

Hi,

I tried this expression,

if(BaselineMonth=YearMonth and Baseline=TDate and not(isnull(trim(BaselineGateVal))),BaselineGateVal,'NA')

but still getting null() values .

[ogautier62]

ok, ther's a last chance,

you still have two values, so must have an agregation function,

maybe :

if(BaselineMonth=YearMonth and Baseline=TDate and not(isnull(trim(BaselineGateVal))),maxString(BaselineGateVal),'NA')