How to exclude a fieldname within a chart

[#1]

I have a chart which totals the cost for "Practices". The chart includes a fieldname called "unallocated" within a dimension called "Practice" and I want to exclude the "unallocated". Any assistance would be appreciated. I have attached the chart.

Thanking you in advance

Claire

[whiteline · Accepted solution]

Use calculated dimension

=if(Practice='unallocated', null(), Practice)

or

=aggr(if(Practice='unallocated', null(), Practice), Practice)