Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
santharubban
Creator III
Creator III

Delta on Pivot Table

Please find the attachment

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)
1 Solution

Accepted Solutions
santharubban
Creator III
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.

 

 

 

View solution in original post

3 Replies
santharubban
Creator III
Creator III
Author

Can anyone please help 

sunny_talwar

Something like this?

image.png

santharubban
Creator III
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.