6 Replies Latest reply on Jun 22, 2018 4:18 PM by Alex Rodriquez

    Count calculation question

    John Thompson

      I want to create a report for the end of a period that will give me the current count of our table games.

      The challenge is in the middle of a period table game themes can change but the table ID stays the same.

      I created a data set with this problem.

      The end result I'm looking for would be something like this:


      Black Jack Game Count at the end of the date range would = 4

      Spanish 21 Game count at the end of the date range would = 2


      I want to sum the cash drop numbers for all games


      I want this to all be in one report


      Any suggestions would be greatly appreciated.


      Thanks in advance.