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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Dept[/TD]
[TD]Name[/TD]
[TD]Activity[/TD]
[TD]Eff%[/TD]
[TD]Present[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]Name1[/TD]
[TD]Actvity1[/TD]
[TD]25%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]Name2[/TD]
[TD]Activity2[/TD]
[TD]15%[/TD]
[TD]63[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]Name Total[/TD]
[TD][/TD]
[TD]40%[/TD]
[TD]63[/TD]
[/TR]
[TR]
[TD]ABC TOTAL[/TD]
[TD][/TD]
[TD][/TD]
[TD]40%[/TD]
[TD]63[/TD]
[/TR]
</tbody>[/TABLE]