1 Reply Latest reply: Sep 19, 2012 3:43 AM by Gregorio Zerpa RSS

    More than 1 calculate dimension -Pivot Table

    Helen Pippard

      Hello,

       

      I was wondering if someone can help me

       

      I have built a pivot table which consists of 4 expressions: Median,Fractile,Longest Time and Over 6 hours

                                                                  1 Dimension: MonthYear

       

       

       

      1 Calculated Dimension: =IF([Patient Admitted?]=1, 'Admitted', 'Non-Admitted')

       

       

       

      I have used a calculated dimension so that I can split the Median and Fractile between "Admitted" or Non Admitted"

       

       

      I now need to have another option which is both admitted and non-admitted added together as "Total", but am not sure whether I need to add another calculated dimension  or my existing calculated dimension needs amending

       

      Thanks

      Helen