mike lee 2 Posted November 15, 2019 Share Posted November 15, 2019 Hi, This kinda worked for me: Avg(if(Rank(baserowid(),"asc",[myGroup1])=1,[Value],Null)) However, only if the chart (clicking on a group) is marked to a specific group. If I unmark the data, then the values are all off. Pls see pictures I hope "picture is worth a thousands words" When marked, 1879.5 is correct. When Unmarked, 1333.50 is incorrect. Thanks in advance. Mike 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