Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Below attached is the pivote table I have created with 3 dimensions 1) Remark 2) Day 3) Bucketing.
In expression I am writing a below condition . But this condition is not changing a font colour.
if(Dimensionality()=0,RGB(0,0,255))
where as if I write a below condition then it is changing all the figs. into blue.
if(Dimensionality()=1,RGB(0,0,255))
Why it is not working properly pl help to resolve issue.
Thanks in advance.
Just add dimensionality() as normal expression into the chart to see the results. Not all all values might be directly listed because they might belong to not shown layers respectively partial sums (therefore you may - just for a testing - enable the partial sums for all included dimensions).
We don't have any attachment, but could be also because you should use secondarydimensionality()?