Using Numbers v5.2 (5869)
Q1 – Working on a dataset of about 1500 Rows and 35 columns. Applied 5 Filters with a couple of ‘or’ conditions in each. Cannot add any other filters – Add a Filter option is greyed out in the Filters tab [next to Categories, Sort]. Is there a limit to the number fo filters which can be applied?
Q2 – Categories are back in this version ! For the same dataset as above, when Subtotaling a Category post-filter, the subtotal does not reflect the filtered data, but the total dataset. Is it feasible to get the subtotal for the category accounting for the filter applied?