Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Why don't you try dimension limit ?
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
Hi!
Your question is a little bit fuzzy. Could you please provide us with detail explanation what you want and what you have?
Thanks.
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
You can try with calculated dimension, expression something like:
=Aggr( if(Rank(Sum([Net Profit]))<4, City), City)
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
In the dimension tab-> tick on , "Supress When Value is Null"
You have to select suppress when value is null in the dimension tab selecting the calculated dimension
-Sundar
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!