I am trying to set up an igx-pivot-grid:
that's exactly what I was looking for, thank you!
Hi Lewis,
Thank you for posting to Infragistics Community!
I have been looking into your questions and was able to reproduce the described behavior by setting up a sample app with a pivot grid, the given configuration and sample data, generated based on the provided members.
After further investigation, I determined that this is due to the default columnDimensionSeparator, which is part of the pivot grid configuration for the pivotKeys. This separator is a dash ‘-‘ and is used when generating the unique column field values. This topic in our documentation lists the available exposed pivotKeys.
In the pivot strategy logic, the part where filter items are generated is the following - link to the code, hence the observed.
To work around this in your scenario, I can suggest altering the columnDimensionSeparator to another character, such as “/”, in the pivot configuration. Here is a small sample I created to demonstrate this. Please, check it out and let me know if you need any further assistance on the matter.
Best regards,Bozhidara PachilovaSoftware Developer