Pivot table expanding doesn't work with label with . character

Question

Hello, when some of the rows have the character '.' as part of the value, expanding and collapsing don't work for those rows.

Is there a way to escape the values so they show but don't mess with the functionality?

Thanks!

Manikandan Murugesan · Accepted Answer

Hi Gonzalo, 
 
We would inform that in our pivot table, we have used Dot(.) as default separator to find the header levels. As a result, the reported issue occurs. To overcome this issue, please change the default separator value by using the "headerDelimiter" property in the "valueSortSettings" option. Please refer the example code below. 

Code Example: 




let dataSourceSettings = { 
  valueSortSettings: { headerDelimiter: ' - ' } 
}; 
 

Meanwhile, we have prepared a sample for your reference. Please find it from below link. 
Sample: https://stackblitz.com/edit/react-rrmmrr 

Please let us know if you have any concerns. 

Regards, 
Manikandan

GUU · Answer

It worked. Thanks!

Manikandan Murugesan · Answer

Hi Gonzalo, 
   
Please let us know if you have any other queries. We are always happy to assist you.  
   
Regards,  
Manikandan