Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think both GetObjectField() function to retrieve the name of the dimension along with the Dimensionality() function could be of great help to you.