How to add label 'Total' in the end of the reports?

Jesus shared this question 3 months ago
Answered

Hi guys, i need to add add label in the end of the reports, i mean 'Total'.

/2oSnZnz8TECAAAAAElFTkSuQmCC

Comments (1)

photo
1

Hi Jesus,

you could either turn on the Column Formatting->Summary->Display Labels:

/wMQrSqaX9V4FwAAAABJRU5ErkJggg==

however that looks a little bit different to your screenshot:

/DzN37BTQiaaNAAAAAElFTkSuQmCC

Or another way that looks more like your screenshot would be to remove the SUM aggregations on the metric columns, then do a UNION subquery, and under the column "Grupo de asignacion" add a calculated field that has the formula ' TOTAL', and then under the column Recuento add a calculated field that has the formula SUM(Recuento) and do similarly for the "Porcentaje" column, then you should end up with something like this:

/DwR1n08aVPT1AAAAAElFTkSuQmCC

I hope that helps you meet your reporting requirements.

regards,

David