topic The pivot table created in qlik saas reporting is giving the total based on the column total but it should give the total based on calculations. in Data Movement & Streaming https://community.qlik.com/t5/Data-Movement-Streaming/The-pivot-table-created-in-qlik-saas-reporting-is-giving-the/m-p/2470923#M2493 <P><STRONG>Hi Everyone. Need a little help in Cloud reporting. The pivot table created in qlik saas reporting is giving the total based on the column total but it should give the total based on calculations.&nbsp;The total should give 0.25 but it is giving 3.41 by adding all the values in the column</STRONG><BR /><STRONG>Below is the screenshot for reference:</STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BhaminiParmar12_0-1721127973393.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169413iAF6E9F5F0107F0A0/image-size/medium?v=v2&amp;px=400" role="button" title="BhaminiParmar12_0-1721127973393.png" alt="BhaminiParmar12_0-1721127973393.png" /></span></P> <P>&nbsp;</P> Wed, 19 Mar 2025 21:58:43 GMT BhaminiParmar12 2025-03-19T21:58:43Z The pivot table created in qlik saas reporting is giving the total based on the column total but it should give the total based on calculations. https://community.qlik.com/t5/Data-Movement-Streaming/The-pivot-table-created-in-qlik-saas-reporting-is-giving-the/m-p/2470923#M2493 <P><STRONG>Hi Everyone. Need a little help in Cloud reporting. The pivot table created in qlik saas reporting is giving the total based on the column total but it should give the total based on calculations.&nbsp;The total should give 0.25 but it is giving 3.41 by adding all the values in the column</STRONG><BR /><STRONG>Below is the screenshot for reference:</STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BhaminiParmar12_0-1721127973393.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169413iAF6E9F5F0107F0A0/image-size/medium?v=v2&amp;px=400" role="button" title="BhaminiParmar12_0-1721127973393.png" alt="BhaminiParmar12_0-1721127973393.png" /></span></P> <P>&nbsp;</P> Wed, 19 Mar 2025 21:58:43 GMT https://community.qlik.com/t5/Data-Movement-Streaming/The-pivot-table-created-in-qlik-saas-reporting-is-giving-the/m-p/2470923#M2493 BhaminiParmar12 2025-03-19T21:58:43Z Re: The pivot table created in qlik saas reporting is giving the total based on the column total but it should give the total based on calculations. https://community.qlik.com/t5/Data-Movement-Streaming/The-pivot-table-created-in-qlik-saas-reporting-is-giving-the/m-p/2470959#M2496 <P>Hi,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/227633">@BhaminiParmar12</a>&nbsp;as per the documentation, pivot tables as not well supported by tabular reporting. Maybe that is causing the issue:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Camilla84_0-1721135889159.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169417i25C62653F7300F73/image-size/medium?v=v2&amp;px=400" role="button" title="Camilla84_0-1721135889159.png" alt="Camilla84_0-1721135889159.png" /></span></P> <P>You can check more info here:&nbsp; <A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Reporting-service-specifications-limitations.htm" target="_blank" rel="noopener">https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Reporting-service-specifications-limitations.htm</A></P> Tue, 16 Jul 2024 13:19:04 GMT https://community.qlik.com/t5/Data-Movement-Streaming/The-pivot-table-created-in-qlik-saas-reporting-is-giving-the/m-p/2470959#M2496 Camilla84 2024-07-16T13:19:04Z