Robin Stoevelaar Posted November 13, 2018 Share Posted November 13, 2018 Hi all, It could be that it is too easy, but I cannot think of a formula or method that gives me the outcome I need. I have a data table containing 4 columns as below ID Position Chances Conversions A 1 3 1 A 1 2 0 A 1 4 2 A 3 6 5 A 1 4 2 A 1 2 2 B 2 6 3 B 2 1 1 B 6 2 2 I made an average on conversions vs chances, I made a cross table so that I can see that ID A made 7 conversions on 15 chances at position 1 etc. etc. But I want to filter on the couple of chances at a particular position, so that I can see the average conversions with a minimum amount of chances at that particular position. (It wouldn't be fair if person B would win with 100% conversion rate at position 6 while only having 2 chances, right) Hope I am clear on what I want to archieve, I hope you could help me. Thanks in advance! Robin Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted January 8, 2019 Share Posted January 8, 2019 Can you provide screenshot of your expected output. As it is not clear how you want to show them. If it in cross table, filtering on chances will automatically populate on those records. Filter cannot be applied to calculated column unless you setup a datafunction to update a document property based on filter selection and then use that document property in the expression of the calculated column 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