Hello,

I’m starting to learn how to use Odoo’s spreadsheet feature, mainly to calculate some ratios and get a clearer view of my window cleaning business.

Right now, I’d like to calculate my LTV (how much revenue an average client generates during the time they remain a client). To do this, I want to use my invoices in a spreadsheet. The issue is that I provide both one-shot services and subscriptions (billed monthly or annually, not per service). If subscription invoices and one-shot invoices are mixed together, I can’t calculate the frequency correctly.

If there were a way to differentiate subscription invoices from the rest, it would solve the problem — but I can’t find which filter or field I could use to hide/show only subscription invoices.

Any ideas?