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.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi toms59,

Right click your table, then create a new column by selecting “New column”  and using the formula as CahabaData’s post. There is an example for your reference as shown in the following screenshot. If you don’t get desired result using this method, please help to post sample data of your scenario and describe the detailed relationships between these datasets.




Thanks,
Lydia Zhang

  • toms59's avatar
    toms59
    Frequent Visitor
    10 years ago

    I tried this but I still couldn't get it to work properly.  Here is a shot of the report I am trying to add the total row to.  Also, I have a shot of the links that I have between the various data sets.  Perhaps I need to join these datasets in some different way.  Any help is appreciated.