Process data table to obtain subtotal table
Hello, I have a Database-like table which resumes Work Orders (WO) and Tasks for those WO where there's as many lines as there's Tasks. For example, I have 5 tasks for the same WO where each has their own planned work hours, actual work hours, planned costs, actual costs, etc : I would like to have a second table, from that table, to show WOs with the subtotals only, and keep WO-related data only : Is it something that can be done? Thanks! PS. I know Matrix can do that, but I don't want show the data necessarily with a table.
Is there a way to subtotal/total column values using alternating columns
We have a matrix that has 2 columns (Amount and Quanity) and the matrix is broken up by Year. So the matrix would look like this Amount/Quantity - Amount/Quantity - Amount/Quantity (with headers above 2005, 2006 and 2007) Question: Is it possible to subtotal/total to the right for just one column (i.e. Amount). Right now if you turn the sub-total/total on, it will add all values across the grid. Can we separate these? This is what we would like to have Thanks, Aaron
