I am using Frappe Cloud and would like to create a Pivot Report with expandable/collapsible rows, similar to an Excel pivot table where users can expand or collapse grouped records.
My requirements are:
-
Hierarchical row grouping (e.g., Department → Employee)
-
Expand/Collapse functionality for each group
-
No custom app or server-side customization, as I am using Frappe Cloud
-
Preferably using standard report features (Report Builder, Query Report, Script Report, or any other supported approach)
Is this type of report currently supported in Frappe Cloud?
If yes, could you please share:
-
Which report type should be used?
-
Whether this is possible through the UI only or via a Script Report?
-
Any documentation or examples demonstrating this functionality?
If it is not currently supported, is there any recommended alternative for achieving a similar user experience?