Difference Metric on Pivot Table

[carlcimino]

Hello I have a Pivot Table with one measure (WP) and I have it broken out by a dimension (SOURCE).  Is there a way to show the difference between the two without creating WP metric for each source?

[Anil_Babu_Samineni]

Yes, we can do. Please attach sample data set

[carlcimino]

DATA:
load * Inline [
ACCT_D,SOURCE,WP
201601,BAR,10
201602,BAR,20
201603,BAR,30
201604,BAR,40
201605,BAR,50
201606,BAR,60
201607,BAR,70
201608,BAR,80
201609,BAR,90
201610,BAR,100
201611,BAR,1110
201612,BAR,123
201601,CMR,1110
201602,CMR,123
201603,CMR,100
201604,CMR,90
201605,CMR,80
201606,CMR,70
201607,CMR,60
201608,CMR,50
201609,CMR,40
201610,CMR,30
201611,CMR,20
201612,CMR,10];

exit script;

[carlcimino]

Hello, Anything on this?  

[Anil_Babu_Samineni · Accepted solution]

I apologies for late respond, Is this what you are expecting?

[carlcimino]

Yes, thank you very much.