Expression

[smilingjohn]

Hi All,

I have the below return code ,

if(Aggr(

  Count(DISTINCT

  {$<

  Date={">=$(StartDate)<=$(EndDate)"},

  Model = ,

  Region_Hierarchy_Name = {'GLOBE'},

  Dept= P(Dept_F)

  >} Revenue

  ), Model

There is a field by name "Model" and content within taht field is like

1-cosmatic , 2-cosmateics , Full-cosmatic , clean -cosmatics, X-cosmatics, 4 -cosmatics ..... and so on ,

Now i want to display count of first 7 models names and above 7 models names should appear like others.

How do i achieve this in the existing code.

Becuase the above code is giving me all the models.

Regards

John

[sunny_talwar]

What is the dimension here? and have you looked into dimension limits if you have  Model_Series as your dimension?

[susovan]

You can try this below attached process to restricted you calculated dimension.

[smilingjohn]

Thanks sunny ,

But there is no dimensions here , there is a long script of the aboive code , and this script will give the output as legends on extention object .

So just need to confirm if there is any way of getting the requirement through the code