Jump to content

Display top 4 Regional sales only via a bar chart


shawnj985

This topic is 4797 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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/

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 4797 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.