Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
carlcimino
Creator II
Creator II

Difference Metric on Pivot Table

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?
Pivot.jpg

Labels (2)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

5 Replies
Anil_Babu_Samineni

Yes, we can do. Please attach sample data set
Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
carlcimino
Creator II
Creator II
Author


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
Creator II
Creator II
Author

Hello, Anything on this?  

Anil_Babu_Samineni

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

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
carlcimino
Creator II
Creator II
Author

Yes, thank you very much.