Forum Discussion
% of Total by Week
Thanks for the quick response!
I've thought of 2 things since reviewing your post:
1. It seems as though the formula you presented isn't given the correct percentages by week. If you see, C in week 2 is below 10%, when it should be 10% on the dot. It seems as though they are cut in half?
2. I've re-read my question, and think I presented my problem incorrectly. My data is really much more like as follows:
| Week | ID | Value | Category |
| 1/1/2016 | 1 | 10 | A |
| 1/1/2016 | 2 | 20 | A |
| 1/1/2016 | 3 | 20 | B |
| 1/1/2016 | 4 | 50 | C |
| 1/8/2016 | 5 | 90 | C |
| 1/8/2016 | 6 | 100 | C |
| 1/8/2016 | 7 | 10 | A |
| 1/8/2016 | 8 | 20 | B |
What I'm actually driving towards is understanding my contributions of the categories, not by the categories. So in the data above, the value field is a means to drive the Category column (a conditional column I've established i.e. "If above x then A if above y then B etc..."). So what I would want to see in my week 1 data point is A = 50%, B = 25%, C = 25%, Week 2 etc... Does that make sense?
I really appreciate your help!
Memorable Memberit is a row count by category you seek. Is the total count for a week always 4 as per your example....or must the week row count also be established?
I believe a "count by week" must be established...if we can get that, then I think I can use a calc field to get my %total by category for each week, correct?