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?