Column headers for key and text

[#1]

Hi all

When displaying both key and text members, AfO only shows the column header in the first of the 2. Eg when looking at Key and Text for 0CUSTOMER, it just shows 'Customer' in the column header of the Key, and the column header of the Text is blank.

Does anyone know if it is possible to also show the column header of the Text column?

Reason: would like to use the AfO table as an input into pivot or powerpivot, as some functions are not yet available in AfO.

Thank you

Bart

[Former Member]

Hi Bart,

I couldnt find any settings which offer to show the Description Column header! But when I used "Covert to Formula" option on the query...I got the below output.....Since you just want a pivot on it....it should be OK?!

[TammyPowlas]

Interesting option; I also tried a formula option to copy over but it doesn't stay when I pivot

[Former Member]

Hmm....Just serached and worked out with that option for Pivot..