$VAR1 = {
          'columnsettings' => 'name,PLU Name,total:count;

total,Sales,total:sum;number:yes;prefix:R

',
          'selector' => '2',
          'data' => 'select

menucat.name catname,

menu.name, 

sum(tods.price * tods.qty) total

from tillordersdetails tods,tillinvoices inv, menu,menu_categories menucat

where tods.invoice = inv.id 

and (inv.voided is null or inv.voided = 0 or inv.voided = 2)

and menu.id = tods.plu 

and menucat.id = menu.menu_category



group by tods.name

;



',
          'description' => 'Sales summary per Category',
          'settings' => '',
          'rollup' => 'catname',
          'id' => '32',
          'title' => '* Per Category',
          'category' => 'SALES',
          'code' => '31'
        };