Avoiding blanks on pivot table

[NavinReddy]

Hello Dear Experts,

i am trying to display the page only Tier1 values for three months for that i am using below expression

=only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}

if ((RAG_RATING_CD) = 'R', '1'))

Here im getting Tier1 including the blanks, i just want to remove the blanks

i need help on restrict the page to only Tier1 values any suggestion

for reference i have attached image

Thanks In Advance,

Niranjan

[sunny_talwar]

I guess use an if statement for all your expressions except for [Tier Status] expression

=If(Len(Trim(Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))) > 0, Expression)

[NavinReddy]

Hi Sunny,

Thanks for your reply

on expression column what you want me to write

=If(Len(Trim(Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))) > 0, Expression)

[sunny_talwar]

I guess all remaning expressions. How many do you have in total?

[NavinReddy]

its will change based on MonthYear selections

you mean to say like below mentioned

suggest me if im wrong

=If(Len(Trim(Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))) > 0,

  only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if ((RAG_RATING_CD) = 'R', '1')))

Thanks,

Niranjan

[NavinReddy]

=If(Len(Trim(Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))) > 0,

  Only({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>} if((RAG_RATING_CD) = 'R', '1')))

with above expression still im getting blanks

Thanks,

Niranjan

[Chanty4u]

hi,

Load

if (Fieldname <> 0,FieldName) as Fieldname

[NavinReddy]

Hi Chanty,

its not actually blanks

im trying to displaying only Tier1(pink) columns

Thanks,

Niranjan

[NavinReddy]

Dear Experts, Any suggestion

[jonathandienst]

You need to apply Sunny's suggestion to all the expressions. To suppress a row, all the expressions must evaluate to exactly zero, or null. If any do not, then the row will be displayed.