https://community.qlik.com/t5/App-Development/Conditional-totals-on-pivot-table/m-p/2505708#M104013 <P>Hi,&nbsp;</P> <P>&nbsp;</P> <P>I want to create a pivot table with 3 dimensions on Row, one on column and I want to show Totals for the dimension on column but I want to show Totals only when there are multiple weeks selected. default view is a bookmark with current week selected so that is one week and for that case I do not want to Show Totals.&nbsp;</P> <P>&nbsp;</P> <P>I also have 3 metrics, so it will show totals per 3 metrics but otherwise I want those 3 metrics permanentely calculated</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>thank you&nbsp;</P> <P>&nbsp;</P> <DIV id="ae_app" data-nosnippet=""><!-- Layout, Style or Voice Helpers --> <DIV id="ae_helpers" class="ae-module" style="display: none;">&nbsp;</DIV> <!-- Compliance --> <DIV id="ae_compliance" class="ae-module" style="display: none;"><!-- For autoSmartRem addNewWindowWarnings div is referenced in an aria-describedby --> <DIV id="audioeye_new_window_message" style="display: none;">Opens in new window</DIV> <DIV id="audioeye_pdf_message" style="display: none;">PDF Download</DIV> <DIV id="audioeye_word_message" style="display: none;">Word Download</DIV> <DIV id="audioeye_excel_message" style="display: none;">Excel Download</DIV> <DIV id="audioeye_powerpoint_message" style="display: none;">PowerPoint Download</DIV> <DIV id="audioeye_document_message" style="display: none;">Document Download</DIV> </DIV> <!-- Versioning Control Panel if versioning = true ! --> <!-- Launcher --> <!-- Toolbar --> <ASIDE id="ae_toolbar" tabindex="0" aria-label="Accessibility options"></ASIDE> <!-- Site Menu --> <!-- Generic Aria Live message container --> <DIV id="ae_enabled_messages" class="ae-blurb-noaudio" aria-relevant="additions" aria-live="assertive">&nbsp;</DIV> <!-- Symbol definitions --> </DIV> <!-- end #ae_app --> Thu, 13 Feb 2025 08:31:08 GMT l26b 2025-02-13T08:31:08Z https://community.qlik.com/t5/App-Development/Conditional-totals-on-pivot-table/m-p/2505708#M104013 <P>Hi,&nbsp;</P> <P>&nbsp;</P> <P>I want to create a pivot table with 3 dimensions on Row, one on column and I want to show Totals for the dimension on column but I want to show Totals only when there are multiple weeks selected. default view is a bookmark with current week selected so that is one week and for that case I do not want to Show Totals.&nbsp;</P> <P>&nbsp;</P> <P>I also have 3 metrics, so it will show totals per 3 metrics but otherwise I want those 3 metrics permanentely calculated</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>thank you&nbsp;</P> <P>&nbsp;</P> <DIV id="ae_app" data-nosnippet=""><!-- Layout, Style or Voice Helpers --> <DIV id="ae_helpers" class="ae-module" style="display: none;">&nbsp;</DIV> <!-- Compliance --> <DIV id="ae_compliance" class="ae-module" style="display: none;"><!-- For autoSmartRem addNewWindowWarnings div is referenced in an aria-describedby --> <DIV id="audioeye_new_window_message" style="display: none;">Opens in new window</DIV> <DIV id="audioeye_pdf_message" style="display: none;">PDF Download</DIV> <DIV id="audioeye_word_message" style="display: none;">Word Download</DIV> <DIV id="audioeye_excel_message" style="display: none;">Excel Download</DIV> <DIV id="audioeye_powerpoint_message" style="display: none;">PowerPoint Download</DIV> <DIV id="audioeye_document_message" style="display: none;">Document Download</DIV> </DIV> <!-- Versioning Control Panel if versioning = true ! --> <!-- Launcher --> <!-- Toolbar --> <ASIDE id="ae_toolbar" tabindex="0" aria-label="Accessibility options"></ASIDE> <!-- Site Menu --> <!-- Generic Aria Live message container --> <DIV id="ae_enabled_messages" class="ae-blurb-noaudio" aria-relevant="additions" aria-live="assertive">&nbsp;</DIV> <!-- Symbol definitions --> </DIV> <!-- end #ae_app --> Thu, 13 Feb 2025 08:31:08 GMT https://community.qlik.com/t5/App-Development/Conditional-totals-on-pivot-table/m-p/2505708#M104013 l26b 2025-02-13T08:31:08Z https://community.qlik.com/t5/App-Development/Conditional-totals-on-pivot-table/m-p/2505774#M104035 <P>You can add the Week dimension twice to columns - one with Totals and one without. Then add "Show column if" as count(distinct Week)=1 on the Week-column without total and count(distinct Week)&gt;1 on the other.</P> <P>&nbsp;</P> <DIV id="ae_app" data-nosnippet=""><!-- Layout, Style or Voice Helpers --> <DIV id="ae_helpers" class="ae-module" style="display: none;">&nbsp;</DIV> <!-- Compliance --> <DIV id="ae_compliance" class="ae-module" style="display: none;"><!-- For autoSmartRem addNewWindowWarnings div is referenced in an aria-describedby --> <DIV id="audioeye_new_window_message" style="display: none;">Opens in new window</DIV> <DIV id="audioeye_pdf_message" style="display: none;">PDF Download</DIV> <DIV id="audioeye_word_message" style="display: none;">Word Download</DIV> <DIV id="audioeye_excel_message" style="display: none;">Excel Download</DIV> <DIV id="audioeye_powerpoint_message" style="display: none;">PowerPoint Download</DIV> <DIV id="audioeye_document_message" style="display: none;">Document Download</DIV> </DIV> <!-- Versioning Control Panel if versioning = true ! --> <!-- Launcher --> <!-- Toolbar --> <!-- Site Menu --> <!-- Generic Aria Live message container --> <DIV id="ae_enabled_messages" class="ae-blurb-noaudio" aria-relevant="additions" aria-live="assertive">&nbsp;</DIV> <!-- Symbol definitions --> </DIV> <!-- end #ae_app --> Thu, 13 Feb 2025 13:55:21 GMT https://community.qlik.com/t5/App-Development/Conditional-totals-on-pivot-table/m-p/2505774#M104035 morgankejerhag 2025-02-13T13:55:21Z