Skip to Content
avatar image
Former Member

Summing a maximum column on a cross tab

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

cross-tab.jpg (1.0 MB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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

    Add comment
    10|10000 characters needed characters exceeded