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

# Count calculation question

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.

• ###### 1. Re: Count calculation question

Hi John,

Here It Is;

Pl Follow the Calcs

Calculation 2 is like this

Thanks

Deepak

If It Helps, Pl mark it Helpful and CORRECT to Close Thread

• ###### 2. Re: Count calculation question

I think you can simply change your measure value from Count, CNT(Table id), to Count Distinct, CNTD(Table ID), to get the result you are looking for.

With Count from your workbook.

With Count Distinct

• ###### 3. Re: Count calculation question

Hi Alex,

Pl have a  look at your Grand Total

This is what I am Getting

Thanks

Deepak

• ###### 4. Re: Count calculation question

That is the same Grand Total you get if you total it using your example.

• ###### 5. Re: Count calculation question

Pl have a look above..it is giving me 6..but I appreciate your method, It is simple, I just pointed out about Total.

Thanks for Pointing out that.

Deepak

• ###### 6. Re: Count calculation question

Strange, when I try it version 10.4, 10.5 and 2018.1 it always totals to 5 and not 6 in your example for me.