5 Replies Latest reply on Dec 10, 2018 11:44 AM by Deepak Rai

# Counting registers

Hi everyone,

I have a really basic database which includes client, activity, date, employee and price. I first counted clientes to know hoy many times a client does an specific activity. Once I get the result i get somethink like this:

Peter   4

Monika  5

George  2

Karen  4

...

Then, I'd like to count how many times each number is got in order to create a percentage graphic where i can see the percentage of each number out of the total. Accordind to the example, I should these percentages:

4   50%

5   25%

2   25%

Any ideas to do it?

Thanks!!

• ###### 2. Re: Counting registers

Hi Deepak Rai! Thank you for your answer, it was really helpful. However, I still have a problem. Values ( 2, 4, 5) aren't a dimension, but they are the result of a counting. I mean, if I put everything on a table, it would be something like that:

Activity    Name    Count

Gym        Peter          4

Monika       5

George      2

Karen        4

Pool       Peter           5

Monika       5

George       3

Karen          2

What I get using your formula is gym = 50% and Pool = 50% (sum of each activity = 15, total is 30 so 50% each one). However, my goal is to get the percentage of the number. I mean:

Activity      Number        %

Gym               4               50%

5               25%

2               25%

Pool               5                 50%

3                25%

2                25%

I'd be really grateful if you could tell me when to do it.

Thanks!

• ###### 3. Re: Counting registers

Hi Victor,

I used LOD, and FIXED LOD can be used as Dimension. Since I don't have data like yours , I created this sample from Superstore . You can use my detailed explanation thing or Single LOD, both will give you same values.

Thanks

Deepak

If it Helps, Pl Mark it Helpful and CORRECT to Close Thread

1 of 1 people found this helpful
• ###### 4. Re: Counting registers

Thank you Deepak!! Problem solved