Hi,

I have generated this report:

However, I want to have the periods on top, so that you can get something like this:

How can I do this? Should I use transpose or cube for this?

Great, thanks

I managed to get all data in my report that I wanted. However I have a strange sorting issue. However, the periodes are not sorted correctly. 2017-3 is in the wrong place

$this->src('yunoport')
            ->query("Select companyname,companyparentid, tblresultid, DATE_FORMAT(tblresultdatetime,'%Y-%m-%d') as resultdate from ci_wizard_results  LEFT JOIN ci_kiosks on ci_wizard_results.tblresultkioskname = ci_kiosks.kioskname LEFT JOIN ci_companies on ci_kiosks.kioskcompanyid = ci_companies.companyid WHERE `tblresultdatetime` >= DATE_FORMAT(DATE_ADD(NOW(),INTERVAL -1 YEAR),'%Y-%m-%d') AND companyname <> ''")
            ->pipe(new Sort(array(
                "companyparentid"=>"asc",
                "tblresultid"=>"desc",
            )))



            ->pipe(new TimeBucket(array(
                "resultdate"=>"month"
            )))
            




            ->pipe(new Cube(array(
                "row"=>"companyname",
                "column"=>"resultdate",
                "count"=>"tblresultid",
                "sort"=>false
            )))
            ->pipe(new ColumnMeta(array(
                "{{all}}"=>array(
                    "type"=>"string",
                    "label"=>"Total",
                    "sort"=>false
                ))))
            ->pipe(new ColumnMeta(array(
                "companyname"=>array(
                    "type"=>"string",
                    "label"=>"Company",
                    "sort"=>false
                ))))





            ->pipe($this->dataStore("wizardresults"));

Thanks!

Can I exclude the company and total columns from the sorting? Because this causes:

ok, solved this by adding names to company & total columns and naming them A & B :)

What I am wondering if I can add a total row as well, of the columns above?

So a row that would show 12 - 2 - 4 - 1 - 5