How to add label 'Total' in the end of the reports?
Answered
Hi guys, i need to add add label in the end of the reports, i mean 'Total'.
Hi guys, i need to add add label in the end of the reports, i mean 'Total'.
The same question
Hi Jesus,
you could either turn on the Column Formatting->Summary->Display Labels:
however that looks a little bit different to your screenshot:
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:
I hope that helps you meet your reporting requirements.
regards,
David
Hi Jesus,
you could either turn on the Column Formatting->Summary->Display Labels:
however that looks a little bit different to your screenshot:
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:
I hope that helps you meet your reporting requirements.
regards,
David
Replies have been locked on this page!