Rollup VS Grouping Sets

[david_ca]

hi everyone,

I have a table that shows the amounts per customer.
These customers belong to categories of customers.
I would like to have the total for each category of customers.
I use in looker "subtotal" by grouping by category while allowing to get the total by customer in the visualization by clicking on ">".
the result is the expected one when the visualization is in "dashboard" format and false when it is in lookml.
  The category total appears for all categories but the totals per customer are correct.
Looking at the generated sql query I see that the lookml uses "GROUPING SETS" while the other "ROLLUP", where the result is correct.