how to hide subtotals for particular measure

[paw1]

Hi,

I have a pivot table with 5 measures. I have to hide subtotal values for only sale %. is there any way to convert sale % sub total value to 0 or completly hide the value.

Sale % = if(FORMAT(SUM(Input[Sales]),"#,##0.00%")="0.00%","-",

FORMAT(SUM(Input[Sales]),"##,###0.00%;(##,###0.00%); -"))

Thanks

[ppm1]

Yes. You can make a new measure like this that references your existing measure and use it instead.

Sale % No subtotals = IF (HASONEVALUE(Table[Company Name]), [Sale %])

Pat

[paw1]

Hi @ppm1 Thanks for your help. It's working fine for subtotals but totals also showing blank along with sub totals. Is there any way to hide only subtotal and show total.

[ppm1 · Accepted solution]

You can use this pattern to do that.

Sale % No subtotals =
IF (
HASONEVALUE ( Table[Company Name] ) || NOT ( ISFILTERED ( Table[Country] ) ),
[Sale %]
)

Pat