Quite a tricky one and not entirely sure how do work it out.
I want to have a different colour layout depending on whether or not there have been more sales in the current month than the same month in the previous year. Eg. Green background in my Invoicing layout if there were more invoices created this June compared to last year in June. I have created count fields as I have report layouts with graphs to show the total sales per month/year.
I Also want to do the same for number of customers who enquire with us . Is this kind of thing doable and if so how should it be executed?