dimension to show sum

[rcorcoran]

I know this is pribably very bad coding but I am looking to show in a table Discharges 3 as Day case Discharges 5 as inpatient discharges which it does but then i want it to show a sum of Discharges 3,4 and 5 as Outpatients.

I have the following to show the first two but don't know how to add in the sum as outpatients

=If(Discharges=3, 'Day Case', If(Discharges=5, 'Inpatient Discharges',null()))

Any help would be great

Thanks

[tresesco]

May be like:

In the dimension limit tab, enable Show total and put the label 'Outpatients'.

[Gysbert_Wassenaar]

If you're talking about a chart expression you can try sum({<Discharges={3,4,5}>}amount) or perhaps count({<Discharges={3,4,5}>} distinct PatientID).