This content has been marked as final. Show 2 replies
I am working on a sales table which has monthly summary till 2016 and have detail transactions for 2017 and 2018.
For the summary table I have a column 'Invoice Count' which is the total number of sales invoices made during the month whereas the detail transaction have Sales Invoice No so her we put a count function to count the total.
How can I show the count of Sales Invoices in one single column? till 2016 it should show sum(Invoice Count) and after that it should show count(Invoice No).