Calculation within pivot table

[#1]

Hi all.

I have a pivot table with to calculations that doesen't give me the right value.I have the right values for every row when the table is collapsed but when the table is expand the "row valuesl" is wrong. Se example below:

Expression for num of events:

count({$<EventCode={'516','521','524','525','526','527'}>} EventCode)

I guess it should be something like this expression but it doesn't work:

sum(aggr(count({$<EventCode={'516','521','524','525','526','527'}>} EventCode), CostCenter))

Suggestions to solve this?

[Gysbert_Wassenaar]

I don't see anything wrong at first glance. I cannot reproduce this. Can you post an example document that demonstrates the problem?

[senpradip007]

Hi.

What's your problem? Can you elaborate on this issue?

[#4]

If you look at the two tables above you can see that the firts table that is collapse the totals for each month is correct but when I expand the table, like the second table, you can see that it is wrong values.  

[tmumaw]

Did you try count({$<EventCode={'516','521','524','525','526','527'}>} Distinct EventCode)

[#6]

Yes, it does not solve the problem.