Few suggestions for the UltrawinPivotGrid when it is bound to FlatDataSource (ordered from what is most important to us):

1. Ability to format on cell or row level. Some of our measures contain mix of volumes, amounts and percentage. We need a way to format percentage differently than volumes and amounts.

2. Custom sorting for hierarchy values. Option to have no sorting would be good too.

3. Option to set row height or control padding. Current row height is way too tall.

4. Option to set initial expansion level before the grid is bound. We like to auto-expand first level, both in the row section and the column section, when the grid’s data source is set. We are currently achieving this with code in the InitializeRow and InitializeColumn events, but find it hard to properly detect if the grid is loading data for first time or the events are firing when the user interacts with the grid.

5. No row expansion on last level of hierarchy with more than one level. We add levels to some hierarchies and those levels vary in depth. One may have just one level while another has four. This is achieved by adding as many levels as there is max and then pass back nothing from the function which returns text for the level. This works, except the last level will have expansion indicator when it should not