I have issue with Subtotals in NPrting

abubakarsiddiq7 — Fri, 15 Nov 2024 22:02:47 GMT

Hi Experts,

I am facing issue on Subtotals in NPriting

In NPrinting, I've created three different levels (dimensions): Area, Region, and Agency, and I'm attempting to get subtotals, but I'm getting subtotals only for Region and Agency, but I'm getting incorrect values for Area. Can anyone help me here ?

Thanks,

Re: I have issue with Subtotals in NPrting

Ruggero_Piccoli — Fri, 09 Sep 2022 09:31:02 GMT

Hi,

Please post Qlik NPrinting questions on its community at https://community.qlik.com/t5/Qlik-NPrinting-Discussions/bd-p/qlik-nprinting-discussions

When you create totals of nested levels using Excel formulas you have to remember to divide because in puter level formulas you are summing the details and their totals. Refer to https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ExcelReports/Excel-Reports-Nesteds.htm. So in the inner level you can simply use =sum(range), in the second level you have to use =sum(range)/2 because it includes the details and the totals of the previous level, and so on.

Best Regards,

Ruggero

topic I have issue with Subtotals in NPrting in Reporting Service & Alerting

I have issue with Subtotals in NPrting

Re: I have issue with Subtotals in NPrting