3 Replies Latest reply: Nov 30, 2012 2:51 AM by Johannes Sunden RSS

Below Function

Manish Kukreti

Hi guys


What is the difference between Below(Field) and Below(TOTAL Field)..???

  • Re: Below Function
    Johannes Sunden

    Total will give you the total over the current dimension.. or a specific dimension if you use Total <DIMNAME> Field.

    Note that if you just use a fieldname and not a function like sum/avg/min/max etc. I think you won't see any difference with the two examples above.

    • Re: Below Function
      Manish Kukreti

      Hi Johannes


      can you also explain me that what is the difference between RowNo() and RowNo(TOTAL)???????

      • Re: Below Function
        Johannes Sunden

        If you have a pivot table with two dimensions:

                       Rowno          Rowno(Total)

        A     X      1                    1

        A     Y     2                    2

        A     Z     3                    3

        B     X     1                    4

        B     Y     2                    5

        B     Z     3                    6


        Hope this makes sense (and looks ok in formatting when posting )