Get Free Trial
Get Free Trial

Customize member caption

Francesco asked on October 1, 2018

We use this simple model:
{
“Item Id”: “ITM01”,
“Item Desc”: “Desc. Item 01”,
“Price”: 174,
“Quantity”: 225,
“Discount”: 23,
“Date”: “2011-01-12”
}
fields “Item Id” is the dimensions on which the pivot works to show grouped “Price”, “Quantity” and “Discount”. Our customers do not want to see a value like “ITM01” but its description “Desc. Item 01”. Grouping by “Item Desc” is not a good idea because more “Item Id” could have the same “Item Desc” but not vice versa.
We have seen that the member object contains the property caption but we have not found any way to customize it. Is it possible to customize this property or to add additional information as shown in the attached image?
Below is the example on jsfiddle: https://jsfiddle.net/bacsacosta/2mnu1p8x/

5 answers

Public
Dmytro Zvazhii Flexmonster October 2, 2018

Hello Francesco,
Thank you for your question. Please find the recommended solution here: https://jsfiddle.net/flexmonster/2mnu1p8x/65/. The combination of member properties and customize cell approach should resolve the issue.
Please let us know if everything works fine for you.
Regards,
Dmytro

Public
Francesco October 2, 2018

Yes, that’s what I needed.
 
Regards
Francesco

Public
Francesco September 22, 2019
Hello Dmytro,

using this approach, with le last version, if the field is used as the root the icon to expand and collapse is no longer rendered. If we use a "classic" field the icon is show.
To reproduce the bug just add the StoreId in Rows area and leave ItemId as first element.

https://jsfiddle.net/flexmonster/2mnu1p8x/65/
Public
Vera Didenko Flexmonster September 24, 2019

Hello, Francesco,

Thank you for writing to us.
 
We would like to explain that the cell.text property contains the expand and sort icons.
So that the icons remain, our team kindly suggests extracting the icons and adding them back when customizing the cell.text property.
 
Here is a modified version of the JSFiddle: https://jsfiddle.net/flexmonster/q6dja1wv/
 
Please let us know if this works fine for you.
 
Best Regards,
Vera

Public
Francesco October 31, 2019

Yes, that’s what I needed.
 
Regards
Francesco

Please login or Register to Submit Answer