Selective subtotals

[NickP_DF]

Hello guys,

in a pivot table with subtotals I'd like to show the subtotals line with the values if the above details row count is greater then 1 and otherwise the subtotals line without the values.

I've tried to work with the Custom format cell by setting the text color equal to the background color if the details row number is 1, but it doesn't work.

Have you got a trick to suggest to me, pls?

(I give a little example about my aim)  

Thanks.

N.

[Kushal_Chawda · Accepted solution]

@NickP_DF   try below

Data:
LOAD * Inline [
Team,Player,Wins
aa,a,100
aa,b,50
bb,c,40
cc,d,90
cc,e,110
dd,f,60 ];

Put below formula in Background color and Text color for measure and Player dimension

=if(sum(total <Team>aggr(Count(Player),Team))=1 and Dimensionality()=1, LightGray())

[NickP_DF]

Great suggestion, Kush!

Thank you so much.

N.