I came across this intresting option sometime back.
I have five sales stage 1 to 5. But I needed to display in the same row / column the sum of stages 1 and 2. To achieve it I used the calculated item option which is provided in the
pivot table.
Steps:
1. Click on any row / column for which you need a new calculated item.
2. In the window that appears, give a name as it must appear in the UI. Create the forumla.I have given sum of two sales stages.
3. The result will be as shown below. We have a new value which has sum of the two sales stages.
But, we need to remember that the calculated items appear in the same order as they were created.
Monday, February 1, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment