Just convert to table your data, then use the table filters to hide those you dont need, then subtotal will work and you can have any quantity of tables you wish
hope this work for u