Pivot Table By Reported and Status #1668

Open salmnan opened this topic on on Oct 17, 2020 - 1 comments

salmnan commented on Oct 17, 2020

DB:

Kindly help me to use Pivot Table By Reported and Status like this pic;

David Winterburn commented on Oct 19, 2020

Please try this:

->pipe(new \koolreport\pivot\processes\Pivot(array(
    "dimensions" => array(
        "row" => array("Reported By", Status")
    ),
    "aggregates" => array(
        "count" => "ID"
    )    
)))
...

Let us know if it's what you want. Thanks!

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo

Labels

None yet

Related package Pivot

KoolReport's Forum

Pivot Table By Reported and Status #1668

Build Your Excellent Data Report