V S Posted March 8, 2020 Share Posted March 8, 2020 Hi, I have a cross table as follows - ColumnA ColumnB ColumnC Store Location Category1 Category2 Category1 Category2 Category1 Category2 Boston 200 100 250 230 230 210 New York 180 150 310 270 240 220 Stockholm 190 140 180 160 220 210 London 170 140 340 310 420 380 I want to calculate the difference between two categories for each Columnsas follows - ColumnA ColumnA Diff ColumnB ColumnB Diff ColumnC ColumnC Diff Store Location Category1 Category2 Category1 Category2 Category1 Category2 Boston 200 100 100 250 230 20 230 210 20 New York 180 150 30 310 270 40 240 220 20 Stockholm 190 140 50 180 160 20 220 210 10 London 170 140 30 340 310 30 420 380 40 My horizontal axes expression is as follows - [Axis.Default.Names] NEST [CategoryName] What custom expression need to use to get it Appreciate any suggestions. Thanks a lot. Link to comment Share on other sites More sharing options...
Naveen Tibco Posted March 9, 2020 Share Posted March 9, 2020 Hello Vcp, please use below expression in cell values of cross table. Regards Naveen 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