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

[settu_periasamy]

Hi,

May be try this for all your expression (already sunindia‌ suggested) except which is showing value '1', i think middle expression

1st Expr:  if(

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

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

2nd Expr : 

if(

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

if ((RAG_RATING_CD) = 'R', '1')) =1, 2nd Expression)

like wise other expression except  this one

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

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

[NavinReddy]

Hi Jonathan,

Good Morning, Thanks for your reply

i have tried but still im getting same, i have attached sample application

please suggests me where im doing wrong

Best Regards,

Niranjan

[NavinReddy]

Hi Settu_Periasamy,

Good Morning, Thanks for your reply

its bit confusing me do you want me to write all the conditions at one place

i have attached sample application

suggest me the right way to do ??

Best Regards,

Niranjan

[settu_periasamy · Accepted solution]

May be like attached?

[NavinReddy]

Thanks so much its working fine