cmcreynolds
Active Member
- Joined
- May 21, 2015
- Messages
- 295
I use Power Query and PowerPivot to grab my data and report in a PowerPivot table.
One table contains my monthly goals; my other table contains the individual pieces and the same categories the goals are in.
My issue deals with summing up the pieces and then COMPARING those sums (simple %, with a calculated field, I hope?) with my goals. But since I have many categories, I'm not sure how to do this.
@Imke, does folding HAVE to be involved, you think?
Thanks for your help.
One table contains my monthly goals; my other table contains the individual pieces and the same categories the goals are in.
My issue deals with summing up the pieces and then COMPARING those sums (simple %, with a calculated field, I hope?) with my goals. But since I have many categories, I'm not sure how to do this.
@Imke, does folding HAVE to be involved, you think?
Thanks for your help.
