Excel Pivot Table Headers

Aljaz Ketis commented on Nov 5, 2021

I want to display a Pivot Table like this:

Currently I have something like this:

How could i Add 2 headers "Id Employe" and "Employe ful name" on bottom of "SUM of Extra Credits" and how could i Add on top of date header "Assigned date"?

Sebastian Morales commented on Nov 8, 2021

The current template for excel pivottable export has not had this format yet. We will explore more formats for excel pivottable for the next version. We will keep you updated in this topic. Tks,

Sebastian Morales commented on Nov 16, 2021

Following up this topic, we've just release a new version of KoolReport Pro and Excel pakcage. There is a new excel widget, PivotMatrix, which should display both the row and column fields in the exported excel file. Hope it is what you have in mind. Rgds,

Aljaz Ketis commented on Nov 16, 2021

Since the documentation is not written yet, can you post here an example of usage with titles and how I can apply styles to it, the same was as in PivotTable

Sebastian Morales commented on Nov 16, 2021

Pls see the code in this example:

[localhost link]

Its setting very similar to excel PivotTable's one. You can just replace \koolreport\excel\PivotTable with \koolreport\excel\PivotMatrix.

Aljaz Ketis commented on Nov 16, 2021

Where is this url located? You posted a localhost url, cannot access it.

Sebastian Morales commented on Nov 16, 2021

My bad, here's the online demo:

https://www.koolreport.com/examples/reports/excel/pivotmatrix/

KoolReport's Forum

Excel Pivot Table Headers #2421

Build Your Excellent Data Report