I love the PIVOTBY function, thanks for that! Any thoughts as to why this formula might return a spill of 8 rows instead of just providing one sum? =PIVOTBY(TblExecutions[Qty],,,SUM,,,,,,) TblExecutions is one complete table. One of the columns in that table is Qty - whole numbers, no subtotals. I used a similar approach on another table, only with a filter and it returned the number I was looking for, but the filter could only return one number. I thought I'd be able to show one "SUM" in this instance as well, but I'm getting a random 8 rows that don't match anything in the table, and the sum of those 8 rows is NOT the sum of Qty in the table.
GOOD STUFF!
Thanks Oz!!!!!!
I love the PIVOTBY function, thanks for that!
Any thoughts as to why this formula might return a spill of 8 rows instead of just providing one sum?
=PIVOTBY(TblExecutions[Qty],,,SUM,,,,,,)
TblExecutions is one complete table. One of the columns in that table is Qty - whole numbers, no subtotals.
I used a similar approach on another table, only with a filter and it returned the number I was looking for, but the filter could only return one number. I thought I'd be able to show one "SUM" in this instance as well, but I'm getting a random 8 rows that don't match anything in the table, and the sum of those 8 rows is NOT the sum of Qty in the table.
You help me, thanks
Happy to help
Is it bug that GROUPBY doesn't show column name if there's single column?