https://community.qlik.com/t5/App-Development/Dynamic-Grouping-and-Subtotal-percentage/m-p/2034932#M85292 <P>I have a scenario</P> <P>Measure assume : Sum(Sales)</P> <P>A: Root level : One Value is selected from the dashboard&nbsp;<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<STRONG>This is the main total for all further calcs</STRONG></P> <P>B: Level 2 : One Value is selected from the dashboard</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Associated value should be shown.</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Unassociated should be grouped into Others.</P> <P>C: Level 3&nbsp; :&nbsp; Associated value should be shown.</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Unassociated should be grouped into Others.</P> <P><span class="lia-unicode-emoji" title=":anguished_face:">😧</span> Level 4 :&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Associated value should be shown.</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Unassociated should be grouped into Others.<BR /><BR />I have to calculate sum(Sales) and % Total for each level using a pivot table.</P> <P>Can someone help me on this scenario</P> Tue, 07 Feb 2023 12:33:38 GMT vaibhavrc09 2023-02-07T12:33:38Z https://community.qlik.com/t5/App-Development/Dynamic-Grouping-and-Subtotal-percentage/m-p/2034932#M85292 <P>I have a scenario</P> <P>Measure assume : Sum(Sales)</P> <P>A: Root level : One Value is selected from the dashboard&nbsp;<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<STRONG>This is the main total for all further calcs</STRONG></P> <P>B: Level 2 : One Value is selected from the dashboard</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Associated value should be shown.</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Unassociated should be grouped into Others.</P> <P>C: Level 3&nbsp; :&nbsp; Associated value should be shown.</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Unassociated should be grouped into Others.</P> <P><span class="lia-unicode-emoji" title=":anguished_face:">😧</span> Level 4 :&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Associated value should be shown.</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Unassociated should be grouped into Others.<BR /><BR />I have to calculate sum(Sales) and % Total for each level using a pivot table.</P> <P>Can someone help me on this scenario</P> Tue, 07 Feb 2023 12:33:38 GMT https://community.qlik.com/t5/App-Development/Dynamic-Grouping-and-Subtotal-percentage/m-p/2034932#M85292 vaibhavrc09 2023-02-07T12:33:38Z https://community.qlik.com/t5/App-Development/Dynamic-Grouping-and-Subtotal-percentage/m-p/2035215#M85312 <P>G'day, this idea is called "Brushing" and I think the best way to do this is with <A href="https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm" target="_self">Set Analysis</A>. In the help page, you can find an example expression which gives you what you're looking for ...</P> <TABLE class="TableStyle-tableGrid" cellspacing="0"> <TBODY> <TR> <TD class="BodyI--"><SPAN class="Code" data-mc-conditions="Targets.NotToTranslate">sum( {1-$} Sales )</SPAN></TD> <TD class="BodyG--">Returns sales for everything excluded by the selection.</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The % total would be something like this ...</P> <LI-CODE lang="markup">sum( Sales ) / sum( total Sales )</LI-CODE> <P>or</P> <LI-CODE lang="markup">sum( Sales ) / sum( {1} Sales )</LI-CODE> <P>I hope this help.</P> <P>Cheers, Barnaby.</P> Tue, 07 Feb 2023 22:31:53 GMT https://community.qlik.com/t5/App-Development/Dynamic-Grouping-and-Subtotal-percentage/m-p/2035215#M85312 barnabyd 2023-02-07T22:31:53Z