topic Re: Color in Pivot table in App Development

Color in Pivot table

Frédéricdh — Tue, 14 May 2024 04:47:19 GMT

I have a Pivot Table with two dimensions the PLACE in the Y Axis and The Week on the X Axis.

The Function is like Sum ({<Place, Week>} Weight)

I colored the background of each Name of The dimension PLACE with a different color and with the Function:

Pick(Match(Place,'A','B','C'), red, green, yellow )

Why when i Select a value in the pivottable the colors disappear?

Re: Color in Pivot table

marcus_sommer — Wed, 15 May 2024 07:56:21 GMT

You may try:

Pick(Match(only({<Place, Week>} Place),'A','B','C'), red, green, yellow )

Re: Color in Pivot table

Frédéricdh — Wed, 15 May 2024 08:04:21 GMT

Thanks you it works but i don't understand why it works?

Re: Color in Pivot table

marcus_sommer — Wed, 15 May 2024 08:18:41 GMT

Your usage of Place within the match() is an implicit call of only() and only returned only a valid value if only a single value is available within the context of the call - otherwise the result is NULL. By extending the call with an explicit only() and extending it with the same set analysis as the sum() to ignore any of these selections both logic are synchronized.