2 Replies Latest reply on Mar 20, 2018 4:49 AM by Miguel Pacheco

# Count how many times an specific dimension occurs

Hi all,

I'm trying to count the total of times that an NRID appear with work status = "not started". Per example following the table below:

 NRID Work Status OBS 12_1 Not Started RED 3452_3 Not Started RED 12343_36 Completed GREEN 97_7 Completed GREEN 12_1 Not Started RED

1 time = a total of 3 (3452_3 & 12343_36 & 97_7)

2 times = a total of 1 (12_1)

So the sum should be like this:

I have done a filter set only with Work status = "not started" and a calculation: { FIXED [Nrid], [Work Status] : COUNT([Nrid])}

and put it like this:

I can put it like graphic example above, but I'm not being able to put the SUMs. It give me the results but with NRID on detail. Every time i take NRID from the detail, it gives me again only the grand total.

Can anyone help me out and say to me what i'm doing wrong here?

MP

• ###### 1. Re: Count how many times an specific dimension occurs

Hi, Miguel

One Thing I want to confirm is, in your sample data, two of them are completed, so it should not be part of the counting. is that correct?

ZZ

1 of 1 people found this helpful
• ###### 2. Re: Count how many times an specific dimension occurs

Hi Zhang,

thanks so much for your reply. Yes, you are correct, the 2 NRID that were completed was not to consider to the counting. I figure what i was doing wrong

I change my LOD to:

{ FIXED [Nrid],[Work Status: Not started]:COUNT([Nrid])}

And also i was not putting on the ROWS the count based on this LOD.

After that, everything goes right.

Thanks again for you great support, and quick reply.

Cheers

MP