function to check the column header or row header is 'total'

[settu_periasamy]

Hi Team,

I need to do one expression, if the the column header or row header is 'total'.

is there any string function to check the column header and row header is 'Total', If i use the dimensionality() and secondary dimensionality, not getting the expected result when we do the collapse and expand.

Just i need to check, if the column header or row header is total, then do some expression.

Find the below pivot table for your reference.

Thanks in Advance.

Regards,

Sethu

[Anonymous]

You can use Dimensionality=Max(Dimensionality) for total columns but for total rows the expressinon SecondaryDimensionality=Max(SecondaryDimensionality()) doesnt work