You need to reshape your data.
In the attached I have a total by day. (See [Total for day] calc). But then to get the percentage of total for the day you would need to make 3 calcs, one for each measure.
Instead of having rows that have all three measures in each row, make three rows per day. Have an extra dimension that has the type of feed (BF intake; ml Breastmilk; ml Formula), and have one measure that is simply [Amount].
for your stacked chart, you will have day on the columns, [Amount] on the rows, and put [feed type] on colors, and that will separate out the same three color chunks for you.
THEN your quick table calc for %of total will work, because it will be working on one measure that is separated by 3 dimension values.
As it stands now, the numbers you are getting are the %of total for each feed type over the span of dates on the sheet.
K feed 2.twbx 72.2 KB
Thank you! I will reshape the data. That seems to be the hardest part - getting the data in the right format!