cancel
Showing results for 
Search instead for 
Did you mean: 

Summing a maximum column on a cross tab

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

JBARLOW
Contributor
0 Kudos

A calculation context should work for a cell in the crosstab

Something like:

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

Example screenshot

Former Member
0 Kudos

Awesome it worked! i appreciate it.

Former Member
0 Kudos

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

JBARLOW
Contributor
0 Kudos

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:

https://archive.sap.com/documents/docs/DOC-74364

Answers (0)