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

    More than 1 calculate dimension -Pivot Table

    Helen Pippard



      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