Only show Subtotal and not the detail within rows (Powerpivot)

[Reiss]

Hi,

Is it possible to create a measure that will only be used as a sub-total.

I have a field in my table called "Present", the data for this is allocated to the top row for the daily records.When this is pivoted all I want to show is the sub-total and not the detail for that particular row.

My data is structured below in a pivot table format. I would like to only show the 63 as a Total and not the red 63 detail.

I am not looking to use conditional formatting as it is unreliable, I tried using sumx but wasn't successful.

Dept	Name	Activity	Eff%	Present
ABC	Name1	Actvity1	25%
ABC	Name2	Activity2	15%	63
ABC	Name Total		40%	63
ABC TOTAL			40%	63

<tbody>
</tbody>