How to calculate expression using only a part of all the 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 in advance.

[sunny_talwar]

I think you need Set Analysis

Sum({<Segment = {'Lumber'}>} Revenue)

[#3]

Right, but with this method, I would have to hard code 'Lumber'.

Is there a method where I select a customer, and the box plot chart updates with the segment data that the customer is in?

[sunny_talwar]

May be like this

Sum({<Customer = , Segment = p(Segment)>} Revenue)

[#5]

Hi, I have this in my boxplot (top, bottom, middle, adjusted appropriately), but it's still showing up as just a straight line.

Fractile({<Customer = , Segment = p(Segment)>}vSOLinesequals/vSOequals,.75)

Could you link me some help threads where I can learn more about this set analysis? I looked around but all I could really find is using '1' or '$' which doesn't help my situation. Thanks

[sunny_talwar]

Check this out

Set Analysis: syntaxes, examples