avg expression

[eva_maria]

Hi!

I'm trying to calculate the number of employees (num) in each position (pto), Empl OK  in my table but I only get Empl (number of total employees)

Year	Num	Pto	Empl (count(total <Pto> Num))	Empl OK
2017	1	com1	4	2
2017	2	com1	4	2
2017	3	com3	4	1
2017	4	com2	4	1

How can i do it?

Regards

[sunny_talwar]

Do you have Pto as one of the dimensions? If not, may be try this

Aggr(NODISTINCT Count(Num), Year, Pto)

[eva_maria]

Sunny, thanks for your qick reply,

Pto is included as chart expression and year is a calculated dimension

I have used your expression, the result is (Empl colum)

Year	Num	Pto	Empl	Empl OK
2017	1	com1	2	2
2017	2	com1	1	2
2017	3	com3	1	1
2017	4	com2	2	1

[sunny_talwar]

Why don't you add Pto as a dimension... and then your original expression ( Count(total <Pto> Num) ) should work

[eva_maria]

Please, see my attached file.

[sunny_talwar · Accepted solution]

Wow, you made it really complex... try this

Dimension

Year

Num

Pto

Expression

Count({$<Year={$(=(Year)-1)}>} TOTAL <Pto> Num)

[eva_maria]

Sunny, no way i can match the results in your link.

Any other opcion??

[sunny_talwar]

What do you mean Eva? I am not sure I understand

[eva_maria]

Hi,

I think it can't be done with Num as a dimension, so i have removed it and that's what i get

Thank you for your patience and interest in helping.

Regards

[sunny_talwar]

But did I just not show you how this can be done?

What is wrong with this?