Bottom Limitation not showing data

[Brysonds]

Hello,

I have a bar chart with one dimension (customer) and one measure (gross margin %).

When I view the bar chart without any limitation, it works fine. e bottom 10, it gives the message "

When I add a limitation on top 10 as a fixed value, it works fine.

However, when I add a limitation on bottom 10 as a fixed value, it says "The selections generated no data for this chart". My expectation is that it would show the last 10 values from the above screenshot.

Any ideas on how to fix this?

[Digvijay_Singh]

Please share your expressions, dimensions etc to understand more about the issue...

[Brysonds]

Hi Digvijay,

The dimension is a text field 'Customer'

The measure is sum(gross profit) / sum(sales)

It works fine for top 10, but bottom 10 is does not work.

[paulcalvet]

I had the same problem, the solution is to agregate in your measure :

sum(aggr(sum(gross profit) / sum(sales),Customer))

[Mark_Little]

Hi 

I believe you expectation are correct and if you are having to aggregate your answer to byt the actual dimension of the chart you have a bug and you should log it. 

You should only need to use aggregation when using dimensions not used or at higher level than your charts