Skip to Content

Summing a maximum column on a cross tab

Jan 18 at 05:12 PM


avatar image

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.


cross-tab.jpg (1.0 MB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
James Barlow Jan 22 at 12:51 PM

A calculation context should work for a cell in the crosstab

Something like:

=Sum(Max([Delay] )In([DAY];[REGION];[Equipment]))

Example screenshot

max.png (42.2 kB)
Show 3 Share
10 |10000 characters needed characters left characters exceeded

Awesome it worked! i appreciate it.


Is there a way to Sum the maximum for a separate individual cell?


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: