Above Function - Not working as I aspect

[#1]

In this example i have 2 identic pivot table.

The 2nd has 3rd dimension expanded and above doesn't work, why?

Maybe i'm tired and don't see this thing .

Thanks to all.

[swuehl · Accepted solution]

Hi Stefano,

yes, that's quite strange looking at first glance. To me, it looks like expanding the node, i.e. the pure visibilty of the dimension affects the column segmentation. Well, reading the HELP about the above functions and other inter chart record functions, I think it should never return you a result, since Location and Time are giving you unique combinations for all rows, building new column segments, right?

(You could see what I am talking about by adding an expression =rowno() and playing around)

I think a workaorund for your needs might be to add an aggr around the above, like

=aggr(above([Event Time]),Location,[Event Time])

Hope this helps,

Stefan

[#3]

Hi Stefan,

rowno() function was been quite clear.

One row of the help says:

The above function without the total qualifier (third column) will only act within each sort group.

I think cause each "Event" is a sort group the above returns null.

Thanks a lot.

Stefano