More than 1 calculate dimension -Pivot Table

[helen_pip]

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

[#2 · Accepted solution]

Hi helen,

You can use partial sum options in pivot table presentacion tab, select the dimension and check this option.

I hope to help you.