but that does not give me distinct payment methods though

how are your search filters and columns setup?

currently, its very simple...

Honestly im not sure how your filters and columns match what you are trying to accomplish

it's a saved search on a subscription that has a custom field that holds payment method... i think i achieved what i wanted by grouping on the customer and counting payment method