Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In pivot table i want to show 'Total of Pqr & Total of Xyz'.
I have writtent an expression
if(Dimensionality()=0, 'Total of ' & Leader2) indicated in red mark below screenshot.
I want to concatenate 'Total of ' with column Leader2. Please help me on this?
Also sample Qlikview file is attached for reference.
You cannot customize the labels for the subtotals. All the subtotal labels in a dimension will get the same text value. You cannot use dimension values for subtotal labels. Maybe you can use the approach from this discussion as an alternative: Custom Labels in Pivot Table