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.