2 Replies Latest reply: Sep 20, 2011 3:43 PM by stefano santini RSS

    Above Function - Not working as I aspect

    stefano santini

      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.

        • Re: Above Function - Not working as I aspect
          Stefan Wühl

          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