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

Reiss

New Member
Joined
Jan 9, 2019
Messages
10
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.

DeptNameActivityEff%Present
ABCName1Actvity125%
ABCName2Activity215%63
ABCName Total40%63
ABC TOTAL40%63

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,099,492
Messages
5,468,927
Members
406,620
Latest member
Gitani123

This Week's Hot Topics

Top