MyXML is hierarchical (location->department->sub
department->revenue). I am trying to create summary rows (for
location, dept, sub dept) and all the examples I see talks about
getting Flat data, creating grouping collection, group fields and
then summary fields.
Since my data is already hierarchical and grouped , do I
still have to group them to create summary fields? I guess the real
question is - Does Hierarchical data structure has any advantages
when compared to Flat structure, when it comes to creating summary
fields? I want to avoid grouping if it is not needed.
Is there an example that uses hierarchical data and creates
summary fields? I would love to see that.