Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I apologies for late respond, Is this what you are expecting?
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;
Hello, Anything on this?
I apologies for late respond, Is this what you are expecting?
Yes, thank you very much.