Getting Error in Calculated Dimension

[NavinReddy]

Dear Experts,

The experssion im using its not working on pivot table

its giving "Error in Calculated Dimension "

=count(aggr(Only({<Month=,RAG_RATING_CD={'R'}, MonthYear={">=$(=date(MonthStart($(vMonth)),'MMM YY'))<=$(=Date($(vMonth),'MMM YY'))"}>}RAG_RATING_CD), Metric))

Can some one help me where i am doing wrong

Any Suggestions

Best Regards,

Niranjan

[NavinReddy]

Hi Sunny,

Sorry for my late reply,

bottom chart have limited dimensions, top chart having all the expression and dimensions

not sure how to get percentage on the same chart

Thanks,

Niranjan

[sunny_talwar]

I am still not sure what you are looking for.

Are you concerned that TireStatus doesn't show last 4 options that are available above? but you are using an if statement in your dimension to get only those, isn't it?

=if((RAG_RATING_CD) = 'R','Tier1',if((RAG_RATING_CD) = 'A','Tier2',if((RAG_RATING_CD)= 'G','Tier3',if((RAG_RATING_CD)= 'NA','Data Not Available or Tier Limits Not Established'))))

What isn't working? Please can you highlight in the image?