Is there any way to accomplish something like this using the PivotGrid:
In this example the measure is volume on one row and amount on other rows. It also has calculations on row level (Average Price and Brokerage Percent).
Two questions:
1. Is there a way to have calculation on row level in the PivotGrid?
2. Is it possible to format on row or cell level?
Thanks Michael,
I may indeed give up on the PivotGrid and custom write this using the UltraGrid. There is much to like about the PivotGrid, but at same time it seems lacking in options.
Thanks,
Trausti
You can suggest new product ideas for future versions (or vote for existing ones) at http://ideas.infragistics.com.
There are many benefits to submitting a product idea:
- Direct communication with our product management team regarding your product idea.- Notifications whenever new information regarding your idea becomes available.- Ability to vote on your favorite product ideas to let us know which ones are the most important to you. You will have ten votes for this and can change which ideas you are voting for at any time.- Allow you to shape the future of our products by requesting new controls and products altogether.- You and other developers can discuss existing product ideas with members of our Product Management team.
Steps to create your idea:
1. Log into the Infragistics Product Idea site at http://ideas.infragistics.com (creating a new login if needed).2. Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)3. Add your product idea and be sure to be specific and provide as much detail as possible.The Product Idea site puts you in the driver's seat and allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.
This would be a new feature request. Perhaps better suited would be our UltraGrid.
eg.
https://ko.infragistics.com/community/forums/f/ultimate-ui-for-windows-forms/94397/wingrid-column-formats-for-different-rows
I was able to achieve the calculated rows by adding one row to the flat data source for every combination of rows that make up the calculation and then handle AggregateMeasure to do the actual calculation. I guess this is doable, but please let me know if there is a way to somehow put in row that does some basic calculation using values from other rows on the same level.
I am still looking for a way to custom format on row or cell level. Please let me know if there is a way to do this.