Rick Vucina Posted April 11, 2022 Share Posted April 11, 2022 Hi, Is there any way for me to divide "Sum 4" by "Sum 3" in a Cross table as per the below example So for the 1st subtotal below for "ABC" Company, I would like to get 87 divided by 26 to get a result of 3.34 Would love an answer, I dont have any experience with Python, etc. Thank you for any help Link to comment Share on other sites More sharing options...
Rick Vucina Posted April 11, 2022 Author Share Posted April 11, 2022 Here is the attachment Link to comment Share on other sites More sharing options...
Jose Leviaguirre 5 Posted April 11, 2022 Share Posted April 11, 2022 Hello @rick.vucina, I am unable to see the image, can you please try to upload the picture again Please use the upload tool to attach the same way you did with the excel file. Link to comment Share on other sites More sharing options...
Kirsten Smith Posted April 11, 2022 Share Posted April 11, 2022 In the "Cell Values" you can add this to the expression: Sum([sum 4])/Sum([sum3]) as [result] to get those values. Link to comment Share on other sites More sharing options...
Rick Vucina Posted April 12, 2022 Author Share Posted April 12, 2022 Kirsten, IT WORKED PERFECTLY, cant thank you enough for taking the time to answer. Thank you again 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