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.
<tbody>
</tbody>
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 |
<tbody>
</tbody>