I have a set of data like
Organisation User Month Type of Copy Volume
Org 1 1 200404 A 20
Org 1 1 200404 B 8
Org 2 2 200404 A 10
Org 2 3 200404 A 15
Org 2 3 200404 B 5
Within this I am creating a pivot table with Organisation and month as page items User as a row field, type of copy as a coulmn and volume as the data. I am trying to add a calculated item to show the volume of B as a % of A. I can create the calculation but when I add it into the data it brings back all of the User numbers rather than those for the selected organisation. I.E. if I have Org 1 selected as the page item it will bring back details for users 1,2 & 3.
Can any body help please
Stewart
Organisation User Month Type of Copy Volume
Org 1 1 200404 A 20
Org 1 1 200404 B 8
Org 2 2 200404 A 10
Org 2 3 200404 A 15
Org 2 3 200404 B 5
Within this I am creating a pivot table with Organisation and month as page items User as a row field, type of copy as a coulmn and volume as the data. I am trying to add a calculated item to show the volume of B as a % of A. I can create the calculation but when I add it into the data it brings back all of the User numbers rather than those for the selected organisation. I.E. if I have Org 1 selected as the page item it will bring back details for users 1,2 & 3.
Can any body help please
Stewart