https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-remove-aggregation-of-subtotals-in-SAS-Visual-Analytics/m-p/843113#M16657 <P>In case you're looking for something like pictured here, you can play with an aggregated measure base expression + cross section expression.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pic3.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/77083i3A1C62F61ED61A37/image-size/large?v=v2&amp;px=999" role="button" title="pic3.png" alt="pic3.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pic2.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/77084i31BC3910812A5442/image-size/large?v=v2&amp;px=999" role="button" title="pic2.png" alt="pic2.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pic1.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/77082iD87C9441F4C15D7D/image-size/large?v=v2&amp;px=999" role="button" title="pic1.png" alt="pic1.png" /></span></P> Tue, 08 Nov 2022 13:39:28 GMT acordes 2022-11-08T13:39:28Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-remove-aggregation-of-subtotals-in-SAS-Visual-Analytics/m-p/843082#M16656 <P><SPAN>How to remove aggregation of subtotals in sas visual analytics crosstab (the data in crosstab object includes 4 category data item and 3 measure data items, The requirement&nbsp;is to show subtotal for only one category level. How can i suppress&nbsp;the subtotals in other category data item?</SPAN></P> Tue, 08 Nov 2022 10:54:55 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-remove-aggregation-of-subtotals-in-SAS-Visual-Analytics/m-p/843082#M16656 hasnasherin 2022-11-08T10:54:55Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-remove-aggregation-of-subtotals-in-SAS-Visual-Analytics/m-p/843113#M16657 <P>In case you're looking for something like pictured here, you can play with an aggregated measure base expression + cross section expression.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pic3.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/77083i3A1C62F61ED61A37/image-size/large?v=v2&amp;px=999" role="button" title="pic3.png" alt="pic3.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pic2.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/77084i31BC3910812A5442/image-size/large?v=v2&amp;px=999" role="button" title="pic2.png" alt="pic2.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pic1.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/77082iD87C9441F4C15D7D/image-size/large?v=v2&amp;px=999" role="button" title="pic1.png" alt="pic1.png" /></span></P> Tue, 08 Nov 2022 13:39:28 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-remove-aggregation-of-subtotals-in-SAS-Visual-Analytics/m-p/843113#M16657 acordes 2022-11-08T13:39:28Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-remove-aggregation-of-subtotals-in-SAS-Visual-Analytics/m-p/847722#M16719 <P>Hi,</P> <P>&nbsp;</P> <P>But in your solution aggregation is coming for only one channel rest are missing.</P> <P>&nbsp;</P> <P>Can you please elaborate on the solution.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Regards,</P> <P>Anurag</P> Mon, 05 Dec 2022 06:26:48 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-remove-aggregation-of-subtotals-in-SAS-Visual-Analytics/m-p/847722#M16719 anuragraishines 2022-12-05T06:26:48Z