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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Watch MrExcel Video

Forum statistics

Threads
1,099,491
Messages
5,468,920
Members
406,620
Latest member
Gitani123

This Week's Hot Topics

Top