Do ZoHo Query Tables support GROUP BY GROUPING SETS?
I am attempting to use the following:
GROUP BY GROUPING SETS (
("Salesperson", DATE_FORMAT("date created", '%Y-%m')), -- Individual month-level data
("Salesperson") -- Rollup for all months
);
I have been unable to find a list of supported SQL commands. Does anyone know if GROUP BY GROUPING SETS is support or if there is a similar command that is supported.