Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=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))
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)
=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))
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
Yes, Over sum have to be there to display the total
Thank you both of you its working
Best Regards,
Niranjan