Is there any way to get Summarised Data / Flattened Data from pivot Table?
Example Config
Row fields: Location > Department > Designation > Employee Type
Column fields: Gender > Band > Grade > Age-Group
Aggregation fie…... Values : Headcount : 2, Average Salary : 1000000, Average..."age_group": "20-30", "headcount": 2, "average_salary": 1000000, "...