Forum Discussion
% of Total by Week
Hey guys, I've been digging around the forums today to try and find a solution, but can't quite find what I'm looking for. I'm trying to make a sparkline of 3 categories of data and their "% ...
v-ljerr-msft, thank you very much! This is so close to the solution I need.
I have double checked my formula to match yours, however, the values I'm getting are greater than 1...however, when I sum up for a given week the result divide by, say, one category's value, it comes out to the correct percentage. Does that make sense?
So for one week I get A = 4.2, B = 2.2, C = 1.1, which is odd. However, 4.2/(4.2+2.2+1.1) is the correct value I'm trying to display, so I know this is close...any thoughts?
v-ljerr-msft
Microsoft Employee
Microsoft EmployeeI have double checked my formula to match yours, however, the values I'm getting are greater than 1...
So could you share your formula and some sample data which can reproduce this issue in your case?
Regards