Forum Discussion

toms59's avatar
toms59
Frequent Visitor
10 years ago
Solved

"Table Report" row total

Here is one I can't figure out.  I have a "Table" report that has multiple sales columns from multiple datasets.  Column 1 has the product description from the master product file dataset; column 2 s...
  • toms59's avatar
    toms59
    10 years ago

    I got it to work using a measure but this is how came out:  Row Total = (sum('Dataset A'[sales 1])+sum('Dataset B'[sales 2])+sum('Dataset C'[sales3]))   Thank you for your help everyone.

CahabaData's avatar
CahabaData
Icon for Memorable Member rankMemorable Member
10 years ago

assuming a related join line between these separate data sets

 

create a Measure 

RowTotal = TableA[ValueField] + Related(TableB[ValueField])