Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have an query in pivot table background colour. from the below image, I have dimensions ITEM,PONO and Measure Sum(PRICE), I need to put background colour fro sum(PRICE) measure with following condition
if(Sum(PRICE)>10,Green(),Red()).
I have achieved the above one.
But the my task is, the colour should come only for PONO not for ITEM. My background color formula should not affect the ITEM(Dimension) .
I have highlighted the ITEM name which i don't what to do colour calculation.
it is possible??
Kindly help me to do this task.
Thanks,
Hi,
so use
if(Dimensionality()=2,
if(sum(PRICE)>10,green(),red())
)
Regards
Hi,
so use
if(Dimensionality()=2,
if(sum(PRICE)>10,green(),red())
)
Regards