Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mccook
Creator
Creator

Pivot Table Visual Cues Query

Hi,

I have used visual cues on my pivot table attached and was wondering if the "Show Partial Sums" Total Rows could be excluded from this?

Maybe visual cues is not the right way of going about this?

Thanks,

Dean

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Yes, there's a better way than Visual Cues. You can click on the + in front of the expression (on the Expressions tab) and click on Background color. There you can enter an expression using the dimensionality() function. If you want to see what that does add an expression to your chart =dimensionality(). You'll see that the partial sums will have a lower number than the detail rows.

You can use that in the expression for the background color. Something like:

if(dimensionality()=2,

     if( sum(MyValue) > 200, red() , green())

)

Change sum(MyValue) > 200 to whatever is appropriate for your situation. Depending on the number of dimensions in your pivot chart you may need another number than 2 in the comparison with dimensionality().


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Yes, there's a better way than Visual Cues. You can click on the + in front of the expression (on the Expressions tab) and click on Background color. There you can enter an expression using the dimensionality() function. If you want to see what that does add an expression to your chart =dimensionality(). You'll see that the partial sums will have a lower number than the detail rows.

You can use that in the expression for the background color. Something like:

if(dimensionality()=2,

     if( sum(MyValue) > 200, red() , green())

)

Change sum(MyValue) > 200 to whatever is appropriate for your situation. Depending on the number of dimensions in your pivot chart you may need another number than 2 in the comparison with dimensionality().


talk is cheap, supply exceeds demand
mccook
Creator
Creator
Author

Works perfectly,


Thanks,


Dean