Want to calculate column total in Nprinting HTML report

[01Nikita]

Hi All,

I want to create HTML report where in UI i have selected show total option due to which the total row is not visible in NPrinting report so please help how can i get total in HTML report  in Nprinting.

Thank You

[Lech_Miszkiewicz]

already discussed here and suggested solution by creating grouping TOTAL dimension: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Nprinting-HTML-Reports-with-Totals-and-Subt...

So if your dim1 has values like in below table (A & B) you need to create grouping dimension (Dim1_Total) which will create values for total too. In this case your total will appear just like any other dimension value in the table.

Note that yo umay need to apply sorting to make sure it is at the bottom of the table

Dim1	Dim1_Total
A	A
B	B
A	TOTAL
B	TOTAL

cheers

Lech

[AlbertoRamirez]

Creating grouping TOTAL can lead to other issues as this is going ti change the data itself and if you have several tables and charts in your dashboard the "Totals" row is going to be shown in all of them and not only in the table you want to use for the nprinting report

[Lech_Miszkiewicz]

Hi @AlbertoRamirez 

That is not entirely true. What you say would happen only if you would use new diemension with TOTAL in all those objects mentioned by you.

The idea is to use this dimension with grouping total only in objects used for NPrinting and that will have no impact on other charts and objects.

cheers

Lech