restrict rows in straight table

[raghavsurya]

Hi,

I want to restrict the number of rows based to 3 on EBITDA values.  I am using this expression to get EBITDA value

Sum({<FY={$(=Max(FY))},GPLParticulars={'EBITDA'},DateID={$(=Max(DateID))}>}PLActual)

can somebody suggest how I can do it.

Regards,

Raghav

[tresesco]

Why don't you try dimension limit ?

[raghavsurya]

Hi,

The dependency to restrict the rows is based on expression value.  I am not able to do in dimension limit.  Please let me know if any work around is there.

Regards,

Raghav

[marchoctober]

Hi!

Your question is a little bit fuzzy. Could you please provide us with detail explanation what you want and what you have?

Thanks.

[raghavsurya]

Hi,

I have to show top performing cities based on Net Profits.  I have one dimension which is city and 4 other expressions showing Revenue, Cost, Gross Profit and Net Profit.  The customer wants to see only top 3 performing cities based on net profit in a straight table chart.

Regards,

Raghav

[tresesco]

You can try with calculated dimension, expression something like:

=Aggr( if(Rank(Sum([Net Profit]))<4, City), City)

[raghavsurya · Accepted solution]

Hi,

I used the Aggr function suggested by you, I am getting a blank row totalling for rest of the cities other than top 3. the customer do not want this blank row.   Is there a way to avoid this.

Regards,

Raghav

[tresesco]

In the dimension tab-> tick on , "Supress When Value is Null"

[sundarakumar]

You have to select suppress when value is null in the dimension tab selecting the calculated dimension

-Sundar

[marchoctober]

Hi

See the attach.

Dimention limit to 3, and further in straight table I sort to required expr., asc or desc.

Note, that if you use expr that is a result of calcualtion based on the values of other expr, f.e. sum(Gross-Cost) so it is ok, but if you will use the construction with Cloumn(1)-Column(2) sorting by double clicking the expr in straigh table will not working.

I hope it will help!