Hi, I am currently trying to export PivotTable to Excel and the PivotTable has computated column like the following:

->pipe(new Pivot([
    "dimensions" => [
        "row" => 'A',
        "column" => [
            "B",
            "C" => [
                "computations" => [
                    "D" => function ($aggRow, $measure) { 
                        ...
                    }
                ]
            ],
            "E"
        ],
    ],
    "aggregates" => [
        "sum" => "F"
    ],
]))

The above PivotTable shows computated column fine in a report. However, once the report gets exported to excel, it somehow misses column 'D' which is computated.

Can we display computated column in exported excel?

Thank you :)

Sorry, I have just found out the problem.

In reportExcel.php, 'hideSubTotalColumns' option of PivotTable widget was on, thereby hiding the computated column like the following:

PivotTable::create([
...
 // Previous
 'hideSubTotalColumns'  => true,
 // Now
 'hideSubTotalColumns'  => false,
...
])

Thanks for the reply :)