For your 1st question regarding % contribution, have a look at the attached application and for 2nd question, you have mentioned that you are going to load data from Database. Are the data for each year would be coming from different tables?
App for Macro.qvw 119.8 K
I put together a quick example for you which uses an expression like:
Sum(Students)/Sum(Total <Year> Students)
and then format it to show as a percentage.
RelativeExp.qvw 134.0 K
Thank you guys for your reply. But I am not getting the percentage still. Its like i dont have ano of hires column , so what I am doing is using this statement:
Count([Emp #])/Count(Total<Year> [Emp #]).
So I am getting a grraph..which is displaying again the same thing like total of 100%...then
Its displaying on different bars....and Y-axis has range till 60%.
What I want is that, it should display y-axis as 100% and then in the 2009 bar it should display like:
M=70% F=30% (I am using a stack graph)
and same for 2010.
I hope I am clear in my explaintation.
Thank you. I would appreciate your replies.:)
ps: @sridar: 2nd Question: its just a point in time table and the current system just pulls the yearly report once a year. So i think its just coming from a single table?