Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
I didn't understand your data model and your graph :
it should work with baselineMonth in dimension,
what is your expression ?
regards
Hi,
Please find the below expression ,
=if(BaselineMonth=YearMonth and Baseline=TDate,BaselineGateVal,'NA')
Thanks,
Vidhya K
you must put an agregation function in your expression, that's why it's null
only or maxstring for example
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
you have two values for BaseLineGateVal : SOE and blank
try this maybe :
if(BaselineMonth=YearMonth and Baseline=TDate and not(isnull(BaselineGateVal)),BaselineGateVal,'NA')
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')
not(isnull(trim(BaselineGateVal)))
to remove blank
Hi,
I tried this expression,
if(BaselineMonth=YearMonth and Baseline=TDate and not(isnull(trim(BaselineGateVal))),BaselineGateVal,'NA')
but still getting null() values .
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')