I am happy to announce that we have been working on integrating Pivoting functionality into ERPNext and have come to a point where it could be developed into an actual module in ERPNext with little community help.
Link to public GitHub repository - https://github.com/asoral/nextpivot
- Search and go to “Self Anlalytics”
- Select a DocType or write a custom SQL Query.
- Click on the “Pivot” button at the top.
We have used the webdatarocks pivot tool. Please suggest if there is a better tool or how can we enhance this and maybe help us develop this into something like “Report Builder” in erpnext