Why can't I add row/columns totals on my tables?

Row/column totals only work on measures (aggregate fields). If you’d like to include a row/column total on a dimension, you can often swap your dimensions for an aggregate.

For example, if you have a dimension for Sale Price, adding a column total won’t work. But if you make that dimension into a measure with a quick aggregation, then that column total will work.

If you want a quick total on a dimension without converting it to a measure, you can use Excel calcs to do so — i.e. " =sum(B:B)" will give you the column total for column B.