Is there a way to get the column name instead of column no in pivot?

[bill_mtc]

Hi,

I have this client requirement to be displayed output on a pivot. However, the formula for Grand Total, Sub Total, and each BU are different. See below the report template:

I tried to get the column no, but if certain group is expanded, the column no for "Grand Total" becomes 1 instead. Looking forward for the help!

Regards,

Bill

[petter]

I think both GetObjectField() function to retrieve the name of the dimension along with the Dimensionality() function could be of great help to you.