KoolReport's Forum

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

How To Create MySQL Pivot Table

Tagged topics

Read if you look for good MySQL Pivot Table solution?

Making a pivot by using MySQL alone is hard, we have tried before so we know how hard it is. Pivot package of KoolReport could be your solution, saving you a ton of time to construct a pivot. All you need to do is to provide a SQL query to get all your raw data and let KoolReport know which columns will be your dimension and which columns you want to aggregate. That's all. KoolReport Pivot will do the hard part to get you the right pivot table instantly.

Searching no more, you have found the best solution to create pivot table! Here are some cool pivot table examples.

Please download KoolReport and get Pivot package!

2
#1861 opened on Jan 23, 2021 by Venom with last post of Venom
1
#1859 opened on Jan 22, 2021 by Venom with last post of Venom
33
#1382 opened on Apr 10, 2020 by ankit with last post of ankit
4
#1365 opened on Mar 31, 2020 by Carl Steenkamp with last post of Carl Steenkamp
2
#1339 opened on Mar 9, 2020 by iRiyada with last post of iRiyada
10
Excel Pivot Table Error. help needed solved
#1336 opened on Mar 6, 2020 by emre with last post of emre
10
#1267 opened on Jan 22, 2020 by prana_chak with last post of prana_chak
2
Questions about Pivot help needed solved
#1206 opened on Dec 5, 2019 by Claudionor Silveira with last post of Claudionor Silveira
5
#1063 opened on Aug 28, 2019 by Alessandro with last post of Alessandro
8
PivotTable value formatting. bug help needed solved
#905 opened on Jun 5, 2019 by Daan Schoofs with last post of Daan Schoofs
8
#441 opened on Aug 31, 2018 by Dimitry with last post of Dimitry
1
#428 opened on Aug 22, 2018 by Zubin with last post of KoolReport
11
Pivot: removing subtotals help needed solved suggestion
#134 opened on Oct 20, 2017 by bysystem with last post of David Winterburn
5
#336 opened on Jun 25, 2018 by V Vijaykumarr with last post of David Winterburn
6
#345 opened on Jul 2, 2018 by shanaka perera with last post of David Winterburn
1
PivotMatrix not displayed help needed solved
#346 opened on Jul 3, 2018 by Jure Zakrajsek with last post of David Winterburn
4
#314 opened on Jun 11, 2018 by V Vijaykumarr with last post of V Vijaykumarr
9
Customized Layout with header bug help needed solved
#313 opened on Jun 11, 2018 by V Vijaykumarr with last post of V Vijaykumarr
9
#194 opened on Jan 16, 2018 by Paulo Morais with last post of KoolReport
2
#115 opened on Sep 19, 2017 by bysystem with last post of bysystem
12
#105 opened on Sep 7, 2017 by bysystem with last post of bysystem
16
#86 opened on Aug 22, 2017 by bysystem with last post of David Winterburn
25
#73 opened on Aug 11, 2017 by bysystem with last post of KoolReport