Hi,
I have a source (and detailed) Smartsheet page with a lot of "detailed" transactions/rows.
I created a report where I'd like to group the data and get some subtotals at the same time.
If you check the picture (my new report), I'd like to group by "Task Name" , sum the "Hours", return the max of the "Estimated duration" and the piece is missing, I'd like to have a calculation at that level (Sum of Hours - Max of Estimated duration"
Please note the "Variance" column is coming from the "source" sheet, but it is not actually needed, as the data per row is not correct. I'd only need the variance at Task level.
Would this be possible?
Thank you
