Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You may try:
Pick(Match(only({<Place, Week>} Place),'A','B','C'), red, green, yellow )
You may try:
Pick(Match(only({<Place, Week>} Place),'A','B','C'), red, green, yellow )
Thanks you it works but i don't understand why it works?
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.