Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i have a situation, i have a pivot table, that has 4 Dimension (for instanse Dim 1, Dim 2, Dim 3, Dim 4) and one Expression.
i created such expression: if(Sum({<Dim = {'Dim2'}>} Sales) > 0.95, rgb(219,219,219)) and it does work, but if i change the order of dimension via drap and drop whitin my pivot,the color expression is still showing.
My Issue, if i select only my Dim2 then the color expression for row should appear, but if i select another Dim, then my colorexpression should disappear.
Does anybody have any idea?
Thanks a lot for your help and feedback
Beck
Hi
I think is because when you click, you're filtering the info.
What happens if you put 1 to your Set Analysis expression?
if(Sum({1<Dim = {'Dim2'}>} Sales) > 0.95, rgb(219,219,219))
Probably now will be different the rule for colouring the cells