Hi,
I need two kinds of table calculations on one sheet, not sure if this is possible. so first, I want to calculate percent of total for each "lower group", that's column "include4", so total of each row divided by total of the table. secondly, I want to calculate "include1"-"include3", which is number in each cell divided by row total. Any suggestion is much appreciated!
include1include2include3include4higher grouplower groupblackpercent of sub totalredpercent of sub totalwhitepercent of sub totalGrand Totalpercent of totalIPIP-17023%14045%10032%3108%IP-29043%12057%0%2106%IP-350056%11012%28031%89024%OPOP-121030%50070%0%71019%OP-241066%0%21034%62017%OP-315056%0%12044%2707%OP-414024%31053%13022%58015%OP-50%0%160100%1604%0%total3750100%
I recognize that this solution isn't ideal, but it is the only solution I came up with when I had a similar problem a while ago. It involves removing the Grand Totals from the first sheet and making a second sheet for the Grand Totals only. Then, you drag both sheets into a dashboard. Since the Grand Total table calculation is calculated as Table (Down) and the other ones are calculated as Table (Across) I think this might be your best bet.
