Forum Discussion
Solved
Adding a Total column in a matrix
Hello, So I am trying to add total column at the end of my matrix that will provide a total by Vehicle that Sums Part cost, Labor cost, and Fuel cost. Fuel costs are not populated yet but will be...
It is a pretty common scenario, not odd. Or you can have a dummy table and add measure in that table, and it is also a common practice.
ChrisAZ, it is still a bit confusing. Do you want this empty column to be calculated dynamically?
Sorry, not sure how I could be more clear on it. I want it to calculate a total column to the right of the others to total up what is in the row all the way down for each vehicle, I just would rather not have the Measure/column have to be stored in one of the many data sets that comprise the other columns.
