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…...data List<Dictionary<string, object>> summarizedData = new List<Dictionary<string...List<Dictionary<string, object>>(); // Iterate through the pivot...