https://communities.sas.com/t5/SAS-Visual-Analytics/The-problem-of-calculate-the-percentage/m-p/348977#M6872 <P>Hi all~</P><P>I want to calculate the percentage of each degree student numbers in each year.</P><P>but if I use aggregated measure to do this, the results are as follows picture.</P><P>&nbsp;</P><P>how can I do so the result will present like each year's percentage sum for 100%.</P><P><IMG src="https://communities.sas.com/kntur85557/attachments/kntur85557/programming/80872/2/pic.jpg" border="0" /></P> Tue, 11 Apr 2017 05:27:38 GMT AmyHsu 2017-04-11T05:27:38Z https://communities.sas.com/t5/SAS-Visual-Analytics/The-problem-of-calculate-the-percentage/m-p/348977#M6872 <P>Hi all~</P><P>I want to calculate the percentage of each degree student numbers in each year.</P><P>but if I use aggregated measure to do this, the results are as follows picture.</P><P>&nbsp;</P><P>how can I do so the result will present like each year's percentage sum for 100%.</P><P><IMG src="https://communities.sas.com/kntur85557/attachments/kntur85557/programming/80872/2/pic.jpg" border="0" /></P> Tue, 11 Apr 2017 05:27:38 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/The-problem-of-calculate-the-percentage/m-p/348977#M6872 AmyHsu 2017-04-11T05:27:38Z https://communities.sas.com/t5/SAS-Visual-Analytics/The-problem-of-calculate-the-percentage/m-p/348970#M6875 <P>Hi all~</P><P>I want to calculate the percentage of each degree student numbers in each year.</P><P>but if I use aggregated measure to do this, the results are as follows picture.</P><P>&nbsp;</P><P>how can I do so the result will present like each year's percentage sum for 100%.</P><P><IMG src="https://communities.sas.com/kntur85557/attachments/kntur85557/sas_va/6875/2/pic.jpg" /></P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/13690i34E8BF23E841E4AD/image-size/large?v=1.0&amp;px=600" border="0" alt="pic.jpg" title="pic.jpg" /> Tue, 11 Apr 2017 08:27:34 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/The-problem-of-calculate-the-percentage/m-p/348970#M6875 AmyHsu 2017-04-11T08:27:34Z https://communities.sas.com/t5/SAS-Visual-Analytics/The-problem-of-calculate-the-percentage/m-p/348974#M6876 <P>What application are you using? SAS, EG, SAS Studio, WRS?&nbsp;</P> <P>&nbsp;</P> <P>I don't recognize the interface&nbsp;</P> Tue, 11 Apr 2017 05:24:04 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/The-problem-of-calculate-the-percentage/m-p/348974#M6876 Reeza 2017-04-11T05:24:04Z https://communities.sas.com/t5/SAS-Visual-Analytics/The-problem-of-calculate-the-percentage/m-p/348976#M6877 <P>sorry ,I should describe it clearly.</P><P>Actucally, I use SAS VA.</P> Tue, 11 Apr 2017 05:27:25 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/The-problem-of-calculate-the-percentage/m-p/348976#M6877 AmyHsu 2017-04-11T05:27:25Z https://communities.sas.com/t5/SAS-Visual-Analytics/The-problem-of-calculate-the-percentage/m-p/348994#M6878 <P>I merged the thread into the one in the VA community.</P> Tue, 11 Apr 2017 06:42:19 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/The-problem-of-calculate-the-percentage/m-p/348994#M6878 Kurt_Bremser 2017-04-11T06:42:19Z