Show all value in pivot table

[Anonymous]

Hi community,

I have Day as column and month as row and

Count(distinct{<FinalFlag ={'new'}>}ACCOUNT_CODE)&'-'&Count(distinct{<FinalFlag ={'inactive'}>}ACCOUNT_CODE)

as expression.

Now i want to include days where FinalFlag is null(I want to show as blank) in pivot table.

Any suggestions on this?

[OmarBenSalem]

How are u defining your FinalFlag field in the script?

[Chanty4u]

if (isnull(fieldname)

Count(distinct{<FinalFlag ={'new'}>}ACCOUNT_CODE)&'-'&Count(distinct{<FinalFlag ={'new'}>}ACCOUNT_CODE))

[Anonymous]

FinalFlag has active,inactive and new status. I want to show new and inactive together in pivot table

[Anonymous]

It shows all days but values are blank

[OmarBenSalem · Accepted solution]

and u have null values for ur FinalFlag ? If so, why?

I'd suggest u to create a new value in ur script for this null() value; and then u can add it in all of ur expression .

maybe sthing like this:

Load *, if (len(trim(FinalFlag))=0,'null',FinalFlag) as newFlag;

load

....,

FinalFlag,

..

from ....;