topic Re: SAS VA 6.1 - New Calculated Item in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-6-1-New-Calculated-Item/m-p/195182#M1557 <HTML><HEAD></HEAD><BODY><P>Hi Ashley,</P><P></P><P><A __default_attr="248651" __jive_macro_name="message" class="jive_macro jive_macro_message" href="https://communities.sas.com/" modifiedtitle="true" title="Re: How to get crosstab columns (monthly) to total 100%, instead of as a sub-percentage of the entire (year) measure?"></A></P><P></P><P>The above given link is the exact topic that what&nbsp; you need about percentage.</P><P></P><P></P><P>Regards,</P><P></P><P>Teja Surapaneni.</P></BODY></HTML> Mon, 09 Mar 2015 10:25:44 GMT TejaSurapaneni 2015-03-09T10:25:44Z SAS VA 6.1 - New Calculated Item https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-6-1-New-Calculated-Item/m-p/195181#M1556 <HTML><HEAD></HEAD><BODY><P>Hope someone can advise please.</P><P></P><P>I am new to SAS VA and we are currently using version 6.1.</P><P></P><P>I have imported some simple data based on Products and Revenue.</P><P></P><P>In Data Explorer, I have created a Cross-Tab that shows Total Revenue by each Product. Next I need to show the Percentage Revenue of the Total Revenue against each Product.</P><P></P><P>When I right click on the drop-down Data tab, then click on the drop-down arrow to select New Calculated Item, it takes me to a screen to build a formula, but I am not sure how to create a Percentage Data Item. Also, I am not sure why I only see Numeric Data Items in this screen, also I don't see Operators such as *, / or count.</P><P></P><P>Perhaps there is a simpler way to calculate a Percentage value?</P><P></P><P>Appreciate any advice.</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 05 Mar 2015 16:52:01 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-6-1-New-Calculated-Item/m-p/195181#M1556 AshleyP 2015-03-05T16:52:01Z Re: SAS VA 6.1 - New Calculated Item https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-6-1-New-Calculated-Item/m-p/195182#M1557 <HTML><HEAD></HEAD><BODY><P>Hi Ashley,</P><P></P><P><A __default_attr="248651" __jive_macro_name="message" class="jive_macro jive_macro_message" href="https://communities.sas.com/" modifiedtitle="true" title="Re: How to get crosstab columns (monthly) to total 100%, instead of as a sub-percentage of the entire (year) measure?"></A></P><P></P><P>The above given link is the exact topic that what&nbsp; you need about percentage.</P><P></P><P></P><P>Regards,</P><P></P><P>Teja Surapaneni.</P></BODY></HTML> Mon, 09 Mar 2015 10:25:44 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-6-1-New-Calculated-Item/m-p/195182#M1557 TejaSurapaneni 2015-03-09T10:25:44Z