0 Replies Latest reply: Sep 16, 2011 1:25 PM by Marc Livingston RSS

    Using dimensionality with dimension results to change expression

      My Situation:

       

      I have 1 dimension that returns 4 results.

       

      Second dimension I set to show partial sums.

       

      So now I have the results of:

       

       

      A

           1

           2

      Total

      B

           1

           2

      Total

      C

           1

           2

      Total

      D

           1

           2

      Total

       

      I need to be able to create different formulas for the different dimension totals.

      Example:

      No A total needed.

      B Total needs to be the total of A and B

      C Total needs to be the totals of A, B and C, but NOT A1

      D Total needs to be the totals of A,B,C, and D, but NOT A1

       

      I then need to have the total of total fields which I could have set to dimensionality()=0

      Example:

      Total of A,B,C,D

       

      Any one have any ideas?