cancel
Showing results for 
Search instead for 
Did you mean: 

Display data in report using mysql "WITH ROLLUP"

Display data in report using mysql "WITH ROLLUP"

Hello Magers,

I want to generate data like below in reports section. Im using getCollection.

 

I'm using default reports block grid for the same.

The problem is i m unable to use "With rollup" command in magento collection.

 

Have logged query and found that query is right with only one group by field. If i specify more than one group by field in array then with Roll up not working. OR else is there any way to change column render or row render ( except public function render($row) ).

Please show me if any one is having any ideas about this.

 

Thanks in advance.

 

 

Page Year Month Date Visit
Australia2016August2009-08-103
Australia2016August2009-08-159
Australia2016AugustTotal12
Australia2016September2009-09-086
Australia2016September2009-09-227
Australia2016SeptemberTotal13
Australia2016Total25
AustraliaTotal25
USA2016April2009-04-044
USA2016April2009-04-142
USA2016AprilTotal6
USA2016February2009-02-063
USA2016February2009-02-244
USA2016FebruaryTotal7
USA2016Total13
USATotal13
Total38