Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I would like to have Color in my Pivot Table when the number is greater then a particular value. But, the Color of the column Total must remain default.
Example:
Sales |
30 |
40 |
50 |
10 |
12 |
14 |
16 |
89 |
83 |
Total: 344 |
Here, i would like to Color all the Columns above 40 with Yellow but, the Total must remain the same.
Thanks!!
No, i have total 4 straight Dimensions from the data model
Will you able to provide one more sample. But Try a luck
=if(Match(Dimensionality(), 1, 2, 3, 4) and Sum(Quantity) > 50,rgb(255,255,0))
See attached, it will give a better idea of my problem
Here it is :
=if(RowNo()<>0 and ColumnNo()<>0 and Sum(Quantity) <> Sum(TOTAL Quantity) and sum(Quantity) > 50, Yellow())
PFA
Thanks, almost perfect.
Say in case i have 3 dimensions(in the sample there is only 1). How can i change the Set Analysis?
don't need to change !
See the attached app once.
I think the coloring is good even here, it looks wrong because you have pivoted the Dimension Field !
I actually want the colors to remain out of the Sum columns even after pivoting.
I probably think that is not possible here, or if some expert could throw more inputs here