Is there way to define cell layout settings (format string, horizontal alignment, etc.) for the measure in XamPivotGrid with multiple measures (XmlaDataSource is used to connect to OLAP Analysis service) in runtime?
Hi Ilya,Please take a look at the following documentation article and this sample for more information on conditional cell formatting. A sample on modifying header and cell templates is available here.If you need more information on the matter, please do not hesitate to ask.Best regards,Milana Zhileva
Hi Milana,
Thanks for your answer. I've seen the samples, but I don't find the answer. I have the follow situation:
I have the pivot grid with 2 measures (e.g. "Amount of Sale" and "Percent of Sales"), "Managers" is placed in row fields area, "Date" ([Year -Quarter - Month - Day]) is placed in columns fields area. I want to display all cells contained "Amount of Sales" as currency (e.g. $123,456.78) and all cells contained "Percent of Sales" as percent (e.g. 12%).
How can I set currency format and specific cell layout style for "Amount of Sale" cells? How can I set percent format and specific cell layout style for "Percent of Sales" cells?
Hello Ilya,
Thank you for your reply. I am very glad that my sample application was helpful for you. Please let me know if you need any further assistance on the matter.
Sincerely,
Krasimir
Developer Support Engineer
Infragistics
www.infragistics.com/support
Hi, Krasimir
Thanks a lot for your sample, it works fine.
Thank you for your reply. I have been looking into your requirements and I can suggest using the CellControlAttached event of the XamPivotGrid. You can define different styles for the different measures and in the CellControlAttached event, you can see which measure is corresponding to the cell and apply the style you wish, using the e.Cell.Style. I have created a sample application for you, that shows how you can implement this approach.
Please let me know if you need any further assistance on the matter.