Tushar Patel Posted September 11, 2019 Share Posted September 11, 2019 I have two data sets which looks like following. No.1 Name Type A B C XX T 1 100 400 100 XX T 2 200 500 200 XX T 3 300 600 300 No.2 Name Type A B C YY T1 50 80 50 YY T2 60 90 60 YY T3 70 100 70 YY T4 10 20 30 I have created a cross table like this. Column Names T1 T2 T3 A 50 140 230 B 320 410 500 C 50 140 230 This cross table is a difference in between No.1 and No.2. I also want to add %difference column for T1, T2 and T3. How can I add those column. The formula for the calculation is easy but I don't know how can I get those values in columns. Desire Result: Column Names T1 % Change T2 % Change T3 % Change A 50 140 230 B 320 410 500 C 50 140 230 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now