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…...and will represent on of the values among Headcount, Average Salary...Grade → 30-40 Age Group 1. Values : Headcount 12, Average Salary...