If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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!
I think both GetObjectField() function to retrieve the name of the dimension along with the Dimensionality() function could be of great help to you.