KoolReport's Forum

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

Pivot table add calculation to the total row #2592

Open kenny opened this topic on on Feb 23, 2022 - 1 comments

kenny commented on Feb 23, 2022

if i want to have a calculation which is calculate with some columns data in the total row, how can i do?

Sebastian Morales commented on Feb 24, 2022

Pls check the Pivot2D process, pipe the result to a datastore and print out the output to see its structure:

https://www.koolreport.com/docs/pivot/pivot2D_process/

Once you understand result of Pivot2D, you could apply a Map process to change the total row value to what you want:

https://www.koolreport.com/docs/processes/map/

If you have any difficulty let us know. Rgds,

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
None yet

None