on 01-18-2018 5:12 PM
I have a cross tab with 3 dimensions on the left and one dimension on the top. The dimension on the top is Filtered by name, which there are two of. I have taken the maximum across each row, shown on the right. I was just wondering if there was a way I could sum the maximum column, either at the bottom of the table or in an independent cell.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Cell references would be the way forward - if you're on at least 4.2 SP3
Just tested and it works fine - brief overview here:
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.