topic Re: Difference Metric on Pivot Table in App Development

Difference Metric on Pivot Table

carlcimino — Sat, 16 Nov 2024 07:03:42 GMT

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?

Re: Difference Metric on Pivot Table

Anil_Babu_Samineni — Thu, 13 Dec 2018 00:31:36 GMT

Yes, we can do. Please attach sample data set

Re: Difference Metric on Pivot Table

carlcimino — Thu, 13 Dec 2018 14:31:21 GMT

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;

Re: Difference Metric on Pivot Table

carlcimino — Thu, 20 Dec 2018 16:49:18 GMT

Hello, Anything on this?

Re: Difference Metric on Pivot Table

Anil_Babu_Samineni — Thu, 20 Dec 2018 23:59:05 GMT

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

Re: Difference Metric on Pivot Table

carlcimino — Fri, 25 Jan 2019 17:04:14 GMT

Yes, thank you very much.