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

[raghavsurya]

hi,

Can you suggest if there is a way to populate the bottom 3 cities as well in a straight table and any option to show top and bottom 3 by click of a button.

Regards,

Raghav

[raghavsurya]

hi,

thanks for your file. Is there a way to change the sort order from descending to ascending by click of a button.

Regards,

Raghav

[tresesco]

Yes, put a negative sign, before sum(). And mark the 'correct answer' correctly the correct one please.

[marchoctober]

Yes. Double click on the appropriate expresion. And user can freely also move the expressions.

[marchoctober]

As for a button, it is makes no sense as it by default integrated in straight table. It could take lots of time to do that by button to you.

[marchoctober]

Do you need only a button?

[raghavsurya]

Thanks a lot for your valuable suggestion

[#9]

Supress When Value is Null"

[Anonymous]

Hi Raghvendra,

You can easily show the top and below amount according to the dimension in straight table bcz in straight table the Dimension limit Tab is available .The problem is occuring when we use the pivot table then in that case we use the aggr() function or calculated dimension..