This may seem like a reasonably daft question and I will admit my brain isn't really working today, I'm trying to generate a purchasing jpivot jobby and would like the ability for example to see both the Product Code AND the Product Code's Description on the same level when someone drills into that level. I've used ordinal column a few times to mask codes with proper labels but our purchasers use both codes and names as references which is a bit of a pain.

So far I've got a the layout correct for my
product group -> product code
dimension which works fine, can I add a column that mirrors that one with product group/code names?

Anyway, any obvious answers??

Cheers

Tom