Forum Discussion
ChrisAZ
Helper V
Helper VAdding 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 your request is not clear...
but u could try creating a measure that calculates the sum of "Part_cost", "Labour_cost" and "Fuel_cost" respectively. Then finally create another measure Total cost = Part_Cost + Labour_Cost + Fuel_Cost
ChrisAZHelper V
Helper VI want a column in the space indicated that is totalling the columns to the left for each vehicle. I know I can create a measure in one of those existing data sets, but I am wondering if there is a way to do it without having to pick one of those data sources to apply it to?