How to calculate expressions using only a part of total data?

[#1]

I'll try to explain the situation as best I can. Any help is appreciated.

I have a Customer table, and a Segment table. Segment lists lines of business, like Lumber, or Roofing, etc. Each Customer is linked with one Segment.

I'm working on a box plot, where the customer will be graphed on, say, revenue, in comparison to the other companies in the Segment.

I can calculate the individual company's revenue just by having it selected.

However, how do I calculate total revenue of just the segment "Lumber"?  The TOTAL and ALL expressions give me all the revenues of all the segments, but I want to compare the customer to just their respective segment.

Thanks.

[sunny_talwar]

Try not to duplicate threads, check my response here:

How to calculate expression using only a part of all the data?

[#3]

I posted this one in the wrong group on accident, and I don't believe I can delete it.

[sunny_talwar]

You can.... there should be an option to delete around this area

[#5]

I know lol, I clicked it, it says I'm unauthorized

[sunny_talwar]

Strange, but okay.... you can close this by marking 'Assumed Answer'