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