Aggregate function - define custom format line by line

[Telerik30]

In my pivot grid, I would like to display my configured formats item by item.


for example suppose I have already defined the format $ for item1, £ for item2 and m² for item3, I want to display this

Feat1
     Item1 $12 $13 $15 $19

     Item2 £22 £23 £25 £29

     Item3 32m² 33m² 35m² 39m²

instead of displaying them all in one global format as (currently possible)

     Item1 $12 $13 $15 $19

     Item2 22 $ 23 $ 25 $ 29

     Item3 32 $ 33 $ 35 $ 39

how could this be handled?

Thank you very much

[Dilyan Traykov]

Hello,

I believe you can use the RowGroup and ColumnGroup properties of the CellAggregateValue to determine what format to apply. In addition, you can use the members of the PropertyAggregateDescription class.

I've prepared a small sample project to demonstrate this approach based on the Custom Cell Template demo from our SDK Samples Browser.

Can you please have a look and let me know if a similar approach would work for you? I will be awaiting your reply.

Regards,
Dilyan Traykov
Progress Telerik

[Dilyan Traykov]

Hello,

One idea that comes to mind is to use the CellTemplateSelector property of the control and determine what format to display based on the row position.

Can you please give this a try and let me know if it would work for you?

Regards,
Dilyan Traykov
Progress Telerik

[Telerik30]

Hello,

Thank you for the answer, indeed I had started this track, my problem is that at the level of my converter, I get my value as "CellAggregateValue", at this stage I do not have enough information, I need for example to know if my group corresponds well to what I want.
I would like to add a TAG to the PropertyGroupDescription when I create it, and get this TAG from my converter to recognize my group, but I don't know if it is possible?

Please let me know if this is clear to you, and if it's possible.

Thanks

Translated with www.DeepL.com/Translator (free version)