https://communities.sas.com/t5/SAS-Visual-Analytics/Addition-and-changing-user-defined-format/m-p/460636#M10123 <P>Hello, I am trying to add qty column according to Dist. Channel(10 &amp; 11) . The format for Dist. Channel is $, as a result, I am not able to add the qty separately according to ID wise i.e. Dist. Channel.&nbsp;</P><P>The result I am looking for is sum of dist. channel 10 &amp; 11 should&nbsp;give me a total of Qty .</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 365px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/20409iA1507417DC050AC6/image-dimensions/365x316?v=v2" width="365" height="316" role="button" title="Capture.JPG" alt="Capture.JPG" /></span></P> Tue, 08 May 2018 07:15:53 GMT madhul 2018-05-08T07:15:53Z https://communities.sas.com/t5/SAS-Visual-Analytics/Addition-and-changing-user-defined-format/m-p/460636#M10123 <P>Hello, I am trying to add qty column according to Dist. Channel(10 &amp; 11) . The format for Dist. Channel is $, as a result, I am not able to add the qty separately according to ID wise i.e. Dist. Channel.&nbsp;</P><P>The result I am looking for is sum of dist. channel 10 &amp; 11 should&nbsp;give me a total of Qty .</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 365px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/20409iA1507417DC050AC6/image-dimensions/365x316?v=v2" width="365" height="316" role="button" title="Capture.JPG" alt="Capture.JPG" /></span></P> Tue, 08 May 2018 07:15:53 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Addition-and-changing-user-defined-format/m-p/460636#M10123 madhul 2018-05-08T07:15:53Z