Aggregate function - define custom format line by line

3 Answers 36 Views
PivotGrid
Telerik30
Top achievements
Rank 1
Iron
Telerik30 asked on 26 Oct 2021, 03:26 PM
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

3 Answers, 1 is accepted

Sort by
0
Accepted
Dilyan Traykov
Telerik team
answered on 04 Nov 2021, 12:11 PM

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

Remote troubleshooting is now easier with Telerik Fiddler Jam. Get the full context to end-users' issues in just three steps! Start your trial here - https://www.telerik.com/fiddler-jam.
0
Dilyan Traykov
Telerik team
answered on 29 Oct 2021, 09:20 AM

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

Remote troubleshooting is now easier with Telerik Fiddler Jam. Get the full context to end-users' issues in just three steps! Start your trial here - https://www.telerik.com/fiddler-jam.
0
Telerik30
Top achievements
Rank 1
Iron
answered on 02 Nov 2021, 09:27 AM

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)

Tags
PivotGrid
Asked by
Telerik30
Top achievements
Rank 1
Iron
Answers by
Dilyan Traykov
Telerik team
Telerik30
Top achievements
Rank 1
Iron
Share this question
or