I want to display a pivot grid that looks something like this:
| Locations ---------------------------------- Code | Description |
Where there is a 1:1 relationship between "Code" and "Description". I can't combine the values into a single column as the user will potentially want to sort on either value.
If I create a three dimensional pivot then one of "Code" or "Description" is below the other in a hierarchy which doesn't make sense and makes the grid look wrong.
Hello Chris,
Thank you for your post. I have been looking into and I created a sample project for you showing the functionality you want. In case your relationship is 1 : 1, you may not define a hierarchy for all Descriptions, which will make the pivot to look like you want. Please let me know if this helps you or you need further assistance on this matter.
Looking forward for your reply.
Thanks for looking into this, but it doesn't appear to be the solution we need.
The two columns are still in a hierarchy, but we need them to be treated as equals.