Partial sum in Pivot tabel

[#1]

Hi,

I have a problem with a pivot table i am trying to set up. I have searched the forums but i cannot seem to find the answer.

I have several persons divided into different groups and age segments. I now want the pivot table to calculate both the partial sums and the total sum of the age groups/person in the columns as expressions. I have tried doing this with dimensionality() function but i cannot seem to get it to work.

Anyone who has an idea?

Cheers,

[giakoum]

does partial sums not work?

[#3]

nope, thank you. thats not what im looking for. i want to be able to see if a persoin has records in a certain age group, and then how many times his records occur in this age group.

[#4]

See the attached file.

[giakoum · Accepted solution]

then a bit of set analysis would do it. see attached

[#6]

thank you, this works fine! follow up question though: when i collapse the diagram the entries shows up as a "-" on group level. I would like this to aggregate to a total - do you know how to do that?

[#7]

Hi Add a Supress option when value is null in a dimesnsion tab for all the values..Find the attached file.

[#8]

hi, could you please build from the file posted by Ioannis Giakoumakis (above). i am sorry i cannot get this to fit in to the excisting build