03-02-2017 06:28 AM - edited 03-02-2017 06:29 AM
I'm using SAS VA 7.2 my sample data is as follows:
Type ItemName Value
Income Services 25000
Income interest received 46500
Income interest -banks 32000
Expense Transit charges 23000
Expense Internet charges 9000
Expense Audit Fees 6000
Expense Bank charges 11000
How can I calculate Percentage of each Expense from Total Income?
% Transit charges from Total Income=?
% Internet charges from Total Income=? and so on...
03-02-2017 08:26 AM - edited 03-02-2017 08:28 AM
Yes Spot on..!!! @ShivamKS,
I've implemented till what you've implemented, was about to update that.
Now I'm struck at this point, let me explain:
let suppose sum percent expenses of income =47.35
where as what i'm trying to achieve is it should be equal to 100% of expenses
i.e., sum percent expenses of income = 100% = Total Expenses %
This is what i'm able to achieve:
03-02-2017 09:15 AM
In the pie chart that values are % of total expense and not % of total income, that is why when you total them they give 100%.
They are two different calculations isn't it? Not sure if i am missing something.
03-03-2017 12:54 AM
Wow Thank you very much @ShivamKS now I've understood how it is working internally.
And I've also understood that SUM of % of Expense from Total Income will not be equal to 100%, as it is calculating separately for
Is there any alternate method to achieve the same?
Please share some inputs on this.