1 Reply Latest reply: Sep 15, 2012 3:42 PM by kevin cool RSS

    Help with Before finction

    kevin cool

      I am using the before function along with rangeavg to calculate forecast sales in  a pivot table.The dimensions are product and MonthYear.It works well but when I keep another dimension OF quarters horizontally above monthyear then all values are zero.The reference manual says this for before function:-

       

      If the pivot table has multiple horizontal dimensions, the current row segment will include only columns

      with the same values as the current column in all dimension rows except for the row showing the last horizontal

      dimension of the inter field sort order. The inter field sort order for horizontal dimensions in pivot

      tables is defined simply by the order of the dimensions from top to bottom

       

      Cant understand what does this mean exactly and how should i modify my pivot table.Could someone please explain this:--

        • Re: Help with Before finction
          Stefan Wühl

          That's just trying to define the so called row segments, though it's quite hard to understand, I agree.

          Have you come across the column segments in a table? Row segments are just the equivalent for horizontal dimensions in a pivot table.

          You can see the row segment bounderies by using rowno() function in your pivot.

           

          I assume you need to apply the TOTAL qualifier to your before function (assuming that you want to ignore the row segment bounderies). Not sure why you get zero for all values, though.

          Can you post your complete dimensions and expression here? Or even better, a small sample file?