Display top 4 Regional sales only via a bar chart

[shawnj985]

Display top 4 Regional sales only via a bar chart

Hello all

I have managed to summarize my data like the following:

Regional name: Total Sales:

A $199,500.00

A $400,100.00

B $344,200.00

C $222,600.00

D $663,800.00

D $199,223.00

E $788,222.00

but I would like to display only the TOTALS of the top 4 regions (bars) via a bar chart. How would I limit the data the chart displays. I'm guessing that it will involved a calc field but not sure how. Thanks in advance.

[comment]

Why does your summary show two regions with the same name?

In any case, this is not a charting question. The real issue here is how to display the totals of the top 4 regions only. Once you solve that, the chart will follow. I don't know the context in which you need this; one option is to remove the other regions data from the found set - see:

http://fmforums.com/forum/topic/69793-limiting-find-to-first-5-records/

[shawnj985]

Why does your summary show two regions with the same name?

In any case, this is not a charting question. The real issue here is how to display the totals of the top 4 regions only. Once you solve that, the chart will follow. I don't know the context in which you need this; one option is to remove the other regions data from the found set - see:

http://fmforums.com/forum/topic/69793-limiting-find-to-first-5-records/

Thanks alot. the link helped.