Apple Numbers % of total in a table?
Is there a way to calculate a table category subtotal percent of the next level subtotal or total. For example calculating what percent of total expenses an expense category is.
MacBook Pro 13″, macOS 10.15
Question marked as
If you don't need the pie chart and just need the numbers, use this:
cell containing the table category subtotal /cell containing the next level subtotal or total
Set the data format of the cell containing the formula to "percent", with 0 places after the decimal.
Regards,
Barry