Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to get the sum of a column based on calculated dimension, i want to restrict the value to top 5 based on category.
i m not able to restrict it. the output is displaying all the values. also and and/or function inside expression is not working out.
can anybody help me out here and suggest where i am going wrong.
below is the expression i am trying to in corporate
IF(Aggr(Rank(-SUM({<DateID={"<=$(=Max(DateID))>=$(=Max(DateID)-3)"},Date=>}abc),4),categ,id)<=5,sum({<DateID={$(=max(DateID)-0)},Date=>}cal),
IF(aggr(SUM({<DateID={"<=$(=Max(DateID))>=$(=Max(DateID)-3)"},Date=>}abc), abc)=0 or Aggr(Rank(SUM({<DateID={$(=max(DateID)-0)},Date=>}cal),4),categ,id)<=5,sum({<DateID={$(=max(DateID)-0)},Date=>}cal)))
Thanks & Regards
Suraj Rao