2 Replies Latest reply: Jan 16, 2018 4:44 AM by Sunny Talwar RSS

    how to show Invoice count

    Mohammad Adnan Ansari

      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).