COUNT(TOTAL Field) In Pivot

[amien]

I'm using COUNT(TOTAL Field) in an expression. I have a dimension that has 2 records.. so it looks something like this:

dim exp total exp

subject1 10 56

------------ 20 56

subject2 12 56

------------ 14 56

what i want is this:

dim exp total exp

subject1 10 30

------------ 20 30

subject2 12 26

------------ 14 26

so i want the count of total of that dimension and not an overall

Thanks in advanced

[#2 · Accepted solution]

Hi Amien,

see the screen shot:

Good luck!

Rainer

[amien]

perfect. . Thanks!