These are not intended to work in the same way. groupBy is simply an equivalent of the GROUP BY clause in standard SQL. In other words table.groupBy($”foo”, $”bar”) is equivalent to: SELECT foo, bar, [agg-expressions] FROM table GROUP BY foo, bar cube is equivalent to CUBE extension to GROUP BY. It takes a list of … Read more
This does exactly what you are asking, checks the rows, and inserts a blank empty row at each change in column A: sub AddBlankRows() ‘ dim iRow as integer, iCol as integer dim oRng as range set oRng=range(“a1”) irow=oRng.row icol=oRng.column do ‘ if cells(irow+1, iCol)<>cells(irow,iCol) then cells(irow+1,iCol).entirerow.insert shift:=xldown irow=irow+2 else irow=irow+1 end if ‘ loop … Read more
If you are on SQL Server 2008 or later version, you can use the ROLLUP() GROUP BY function: SELECT Type = ISNULL(Type, ‘Total’), TotalSales = SUM(TotalSales) FROM atable GROUP BY ROLLUP(Type) ; This assumes that the Type column cannot have NULLs and so the NULL in this query would indicate the rollup row, the one … Read more