cancel
Showing results for
Did you mean:
Creator III

Delta on Pivot Table

This Data:

 Program Milestone Control Model Commodity Cost Program 1 C1 Part A (\$78.36) Program 1 C1 Part A 0 Program 1 C1 Part B (\$44.31) Program 1 C1 Part B 0 Program 1 C1 Part B (\$1.98) Program 1 C1 Part B (\$0.98) Program 1 C1 Part B \$0.02 Program 1 C1 Part B (\$13.32) Program 1 C1 Part B (\$6.16) Program 1 C1 Part B (\$9.57) Program 1 C1 Part C (\$5.55) Program 1 C1 Part C (\$5.44) Program 2 C2 Part A (\$58.30) Program 2 C2 Part B (\$0.15) Program 2 C2 Part B (\$0.15) Program 2 C2 Part B (\$5.41) Program 2 C2 Part B (\$15.02) Program 3 C3 Part B (\$12.96) Program 3 C3 Part B (\$5.16) Program 3 C3 Part B (\$8.57) Program 3 C3 Part C (\$6.55) Program 3 C3 Part C (\$4.44)

Thanks

KSS

Labels (1)
• Developer

1 Solution

Accepted Solutions
Creator III
Author

Thanks Talwar.

Yes, this will also worked, but i have figured out a simple this solution.

Expression 1:

Sum(Cost)

Expression 2 :

Sum(cost) - First(Sum(cost))  which will give a delta.

3 Replies
Creator III
Author

MVP

Something like this?

Creator III
Author

Thanks Talwar.

Yes, this will also worked, but i have figured out a simple this solution.

Expression 1:

Sum(Cost)

Expression 2 :

Sum(cost) - First(Sum(cost))  which will give a delta.

Community Browser