Forum Discussion
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...
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
Memorable Member
Memorable MemberI misinterpreted your original report - if all this data is in a single table/report then you rely on the simpler math
I don't think in this case since it is all within the same table/report you even need to specify the table
RowTotal = [ValueField1] + [ValueField2] + etc
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.