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

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,096,448
Messages
5,450,514
Members
405,614
Latest member
SJ789

This Week's Hot Topics

Top