I have created a Custom Summary by Indicating in the Layout portion that a field "Measure" should be summed - this works fine and gives me a summary below the data, but the problem is that there are 10 different items withing a measure so for;
Membership, yes I want a total, and Admits I want a total, but for the Admits/K I do not want a total, I want a calculation (Admits *1000/Membership"
How can I change the fact that it is summing and put my own calc in.
data looks like this.
State Measure
ID Membership 204.7
Admits 1
Admits/K 19.5
OR Membership 78.3
Admits 1
Admits/K 51.1
So my summary data is totaling up
Membership 283 (this is what i want)
Admits 2 (also what I want)
Admits/K 70.6 (don't want a total, want to do a calc here)
it won't let me add a calculated item to the summary area giving me an error "Can not change this part of a PivotTable"
Membership, yes I want a total, and Admits I want a total, but for the Admits/K I do not want a total, I want a calculation (Admits *1000/Membership"
How can I change the fact that it is summing and put my own calc in.
data looks like this.
State Measure
ID Membership 204.7
Admits 1
Admits/K 19.5
OR Membership 78.3
Admits 1
Admits/K 51.1
So my summary data is totaling up
Membership 283 (this is what i want)
Admits 2 (also what I want)
Admits/K 70.6 (don't want a total, want to do a calc here)
it won't let me add a calculated item to the summary area giving me an error "Can not change this part of a PivotTable"