Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
i create a pivot table.
1 field: Fabio
2^ field: Mazzarelli
I wish to create a 3th field ... Fabio Mazzarelli
Is it possible and howto?
Calculated Dimension
1st Field & 2nd Field
Not sure if I understand, but may be this:
Field1 & ' ' & Field2
ABsolutely. In Sense you need to create a new dimension in master items and include it in your pivot table. The syntax Sunny provided will work for this.
REgards
Andy