GROUP BY Pivot table

[MBV]

Hey Guys,

I tried to calculate the Sum of Obligo and YTD.

The first table shows the sum of all transactions grouped by FP (Every FP contains several EKG). That worked fine.

The second table should show the sum grouped by the EKG but it is calculating the same as above for every EKG. 

Why is it ignoring the EKG?

I'd be very grateful for your help!

[dplr-rn]

from a quick look it looks as if the association between column EKG and rest seems to be the issue.

i would say check you data mode and put into a raw table and see what the output is

[Brett_Bleess]

If Dilip's comment got you what you needed, be sure to close out your thread by returning to the post and using the Accept as Solution button on his post.  I do agree with him, the only other thing of which I can think would be something in your Expression not being correct, which I did not see posted, so that makes it difficult for someone to be able to offer further help.  We would really appreciate it if you can close things out or leave an update for us.

Regards,
Brett