Matching a field selection to another field set Expression

[#1]

Hi Guys,

I'm trying to create the following tables.  The expression I want is to sum up the revenue where the Dimension is equal to either the Shipper or Consignee Name.

The only way I've though of to do this was using a data island, however both these fields are quite large, I would like to avoid duplicating this data in a data island if possible.  Any suggestions?  An example would be for the dimension "Credit Valley Hospital" the expression should sum up all revenue where "Credit Valley Hospital" is the Shipper or Consignee.  Thanks in advance.

[pauljohansson]

Hi,

If I understood you right you should be able to "tag" your data by adding a column specifying if the data is "Shipper" or "Consignee Name"

Then you should be able to concatenate your tables creating ONE table looking something like:

Charge      Type           Name

100             Shipper    Credit Valley Hospital

br

Paul