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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,096,363
Messages
5,449,990
Members
405,581
Latest member
caliope1990

This Week's Hot Topics

Top