Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
845
How can I display a pivot where two of the dimensions have a 1:1 relationship and are just two aspects of the same thing?
posted

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.