Expression Not Working in pivot table

[NavinReddy]

Hi Dear Experts,

=

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

and

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

and

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

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

I have one expression its not working in pivot table, the same expression working fine in list box

i have used same dimension in pivot and list box

can some one help me what is the error, for reference please find below image

Thanks In Advance

Niranjan

[sunny_talwar]

May be this:

=Aggr(

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

and

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

and

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

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

[Kushal_Chawda · Accepted solution]

=sum(aggr(if(Count({<Month=,RAG_RATING_CD={'R'}, MonthYear={">=$(=date(MonthStart($(vMonth)),'MMM YY'))<=$(=Date($(vMonth),'MMM YY'))"}>}RAG_RATING_CD)=1

and

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

and

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

Count({<Month=,RAG_RATING_CD={'R'}, MonthYear={">=$(=date(MonthStart($(vMonth)),'MMM YY'))<=$(=Date($(vMonth),'MMM YY'))"}>}RAG_RATING_CD)), PivotTableDimension))

[sunny_talwar]

From the looks, OP seems to be using this as a dimension. But you are right, if this is an expression, then he might need to add out aggregation such as Sum

[Kushal_Chawda]

Yes, Over sum have to be there to display the total

[NavinReddy]

Thank you both of you its working

Best Regards,

Niranjan