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/
⋅ 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
⋅ October 2, 2018
Yes, that's what I needed.
Regards
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/.
⋅ 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
⋅ October 31, 2019
Yes, that’s what I needed.
Regards
Francesco