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