KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Pivot table custom row drill down in a column #465

Open Henry Eko H opened this topic on on Sep 13, 2018 - 1 comments

Henry Eko H commented on Sep 13, 2018

Dear support,

is it possible to make pivot table row, when drilled, is not expanding to the right. but rather, expand to below the expanded row?

for example, in the pivot example pivot by years months costumer categories when the customer row is expanded, the category field is add below the expanded row. and the total row is grouped in the expanded row.

just like old timer ms excel pivot

David Winterburn commented on Sep 14, 2018

Hi Henry,

That's a nice idea and could save a lot of blank spaces. We will explore options to see if it's possible as this requires major rewriting of the pivot table/matrix's interface.

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
help needed

Pivot