Katie Sikorski Posted February 8, 2021 Share Posted February 8, 2021 I have a table that has Operator, Gas Oil and Date in monthly Values. I tried Count of Operator and Unique Count but neither gave me the values I need. All I want is to count the Operators and not the seperate monthly values. So if a operator has 200 wells not matter how many lines I want the count to be 200 and the oil and gas summed not counting the operator lines if this makes sense. So what it is doing is counting every monthly line istead. So the example below is what I want: Operator Count Sum_Oil Sum_Gas Operator1 145 125 6021 Operator2 203 33 9164 Operator3 240 210 11567 Operator 4 15 16 675 Right now I am getting this: Operator Count Oil Gas Operator1 293 256 4537 Operator1 293 156 4025 Operator1 293 133 3790 Operator1 293 210 2897 Operator1 293 162 4999 Link to comment Share on other sites More sharing options...
Fabian Duerr Posted February 8, 2021 Share Posted February 8, 2021 It's a valuable information for us how your source data looks like. And also, if you want to have a cross table, a new data table (pivot) or calculated columns. 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