Hi Brian,

I need to be able to do the same thing. From what I can infer from your example above, you would have to add a Group per salesperson programmicatlly. Is that right?

If at all possible, could you please post a full example?

Thanks,

Suthan

Hi Mark,

The PivotGrid control is relatively new, so in order to use it or see the samples, you would need to purchase the Infragistics control for a recent version that includes that control. So we cannot provide you with a sample of using the PivotGrid in v12 or under because the PivotGrid control did not exist in those versions.

Hello Boris

I do not see these samples.

Could you provide a link within the infragistics website that has this sample.

Also this sample should be with Infragistics version 12 and under as that version does not have the new pivot grid.

Thanks.

Hello merlon,

You could see a sample regarding this in our 'Windows Forms Feature Browser'.

If you have this installed(if you have marked 'Samples' when installing Net Advantage), you could run it from 'Start Menu' -> 'All Programs' -> 'Infragistics' -> 'Windows Forms' -> 'Samples' -> 'Samples (local)'.

When it loads, please navigate to the 'Grids' tab and then 'Launch' the 'Samples Explorer' sample. Or you can type in the 'Search:' "'Samples Explorer'". In the opened window please find 'V9.1 Groups in RowLayout Mode' sample, it could guide you in your scenario.

Please do not hesitate to contact us if you need any additional assistance.

Hi Brian,

Please disregard my previous question as it is incomplete.

Is possible to convert a data source that is formatted as a table or object, such as the one below, to look like the pivot table posted by divu15.

From your example, it would seem that I would need to create a column for each sales person and property you may want to pivot. So if we were to have 20 sales people, you would need to create 40 columns and 20 groups to achieve the pivot? By the way, would product be a group with one column associated with it?

Thanks