Like your newly released version of the xamgrid I would love to be able to use string indexers for measures within the xampivotgrid (which is great BTW and was desperately needed).
Is there anyway to manually add measures for the flatdatasource that would allow the pivotgrid to display data from a collection of data on a data class?
Thanks in advance for any tips.
Doug
Hi Todor,
Basically I have a class called Product which has a collection of store numeric values. I want to be able to display the list of store names as measures so the users can display sum totals etc for each store numeric value against the list of products. If my Product class has a public property for each store, then it is easy and I can already get that working, but I dont really want a public property for the store but rather just a dictionary of all the store names and their values.
Regards,Doug
Hi Doug,
The flatdatasource is designed to work with table structured data. This means that it analyze data row by row and is not predicted to analyze relational data.
I will give you a sample. If you have 3 tables in your database: Seller, Product and Sale, you have to make a view on these 3 tables and join them together. After that you put the view to the flatdatasource for analyst.
If you describe your case in more details may be I will be able to give you a more specific advice.
Regards
Todor