on 10-30-2017 3:28 PM
Hi all,
I have a requirement to get the maximum value based on two dimensions. Below is the data.
I need to get the maximum "Sequence 2" value for every unique "Planned Year Quarter" in a unique "Project."
Below is the formula I inserted for "Test1" but I get incorrect results.
=Max[Sequence 2] ForEach ([Planned End Year Quarter])) In ([Project])
Can someone please help me with the correct formula.
Thanks.
try this.
=Max[Sequence2] IN ([Planned End Year Quarter];[Project])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.