How to SUM a value once (instead of per column)

[Anonymous]

I have a table that is created by a UNION of several other tables.

The UNION of several tables effectively counts recordIDs. Here's the code creating that table:

UNION and SELECT COLUMNS generating the table in question

One of the fields in the 'Campaign Sourced & Influenced' table is 'Amount'. I'd like to SUM amount for only one of the columns, the related 'Campaign Sourced and Influenced OTY'.

Original table created by Union and Select Columns

Using the field 'Amount' and summing it as a value almost works except the SUM appears with every Column generated by the UNION table. 

The SUM appears with every column. I don't want that

How can I SUM the 'Amount' for only one column, Campaign Sourced and Influenced OTY' and put it next to that column?

[Anonymous]

Solved it another way. 

Take a step back and question if the UNION method makes sense? (it doesn't - theres a much easier way)

Since the table is related in the model, simply create quick measures and drop them into the values.

a bunch of quick measures created in the UNION table

Here's the output.

Counts and SUMs as they should be

[kentyler]

Have you considered doing the Sum before you do the union. 

You would have to create a dummy field in the tables in the union that do not show the sum.