Show only some data in graph

[#1]

Hi,  

I have a graph with:

- dimension : Person

- espression: SUM(measuse)

I want to show in my table only Person that have SUM(measure) over a certain amout.

You know how to do that?

thank u!

[its_anandrjs]

Hi,

In addition to this is Dimension Limits tab controls the number of dimension values in your chart. And it depends on the option that you selected and according to that it produces the result. The dropdown contains three values: First, Largest and Smallest. These values control the way the calculation is completed and representing your chart. It is compulsary that you select one of this option.

Hope this helps

Thanks & Regards

[#3]

Sorry but I can't undersand, for example, if I want only person with SUM(measure)>1000, what should I write in the tab "Dimension Limit"?

[#4]

It works thank u!

[Colin-Albert]

Tick the box "Restrict which values are shown using the first expression"

Select

     "Show only values that are"  "Greater Than"   enter the limit value, say 200

then select

     "exact amount"

[#6]

Thank u very much!

[#7]

excuse me again 'cause now I have a new question (if it's not good here I can open another Discussion but maybe you know the answer).

I thought that "dimesion limit" evaluetes the value of dimension and not the first measure. So, now, what can I do for really limit the value of "dimension"? For examle, same of before:

- dimension : Person

- expression: SUM(measuse)

how can I have a table with only the top 5 person in alphabetical order?

thank u!