I have a spreadsheet to keep track of what I eat daily:
Date | FoodItem | Protein | Fat | Carbs | TotalGrams |
---|---|---|---|---|---|
Based on this I defined a pivot:
Data | ||||
---|---|---|---|---|
Date | Sum - Protein | Sum - Fat | Sum - Carbs | Sum - TotalGrams |
Total Result |
This is all in grams. How do I now calculate % of Protein, Fat, Carbs, per day? I can do this by adding formulas outside the pivot, but then it is hard-bound to cells. I there is any change in pivot, then all references will fail.
Thanks