Hi Mynda,
When i tried to convert the pivot to OLAP column headers not getting converted. I am not sure what the reason is. I tried on few files but issue remain same with all files. Because the data i am dealing with are very sensitive. I have created a simple pivot table as a test file.
If you can please help with this issue it will be greatly appreciated.
Thanking you in advance
Anura
Hi Anura,
Welcome to our forum! Thanks for sharing your file.
In this case your column headers are the field names. These don't get converted into CUBE formulas. If you were to put a field into the column labels area of your PivotTable, the items that then appear as column labels would become CUBE formulas.
Currently your PivotTable only contains row labels and the column headers are actually the field names, not items from within those columns.
Hope that clarifies things.
Mynda
