Customize member caption

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/

2 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

Please login or Register to Submit Answer