Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot tables with numbers that represent percentages (0,25,50,75,100). My totals are average of the percentages which might be a number with decimals. I use Show Partial sums option on the Presentation Tab
and my expression is
=(sum(A])/count())/100
I want to replace cell's values with "Consumer Report" like circles. I do it with the if statement on the expression like:
=if (Match(,'100'),'qmem://Image Name/100',
if (Match(,'75'),'qmem://Image Name/75',
if (Match(,'50'),'qmem://Image Name/50',
if (Match(,'25'),'qmem://Image Name/25',
if (Match(,'0'),'qmem://Image Name/0')))))
, but as soon as I do it the totals are also got replaced with images. How can I leave totals as numbers?
Any Ideas? Thank you
try using column function like
if ( column(1)<20 ,'Image1,
if(column(1)>40,'Image2','Image3')
Hope it helps
Sri1
were would I use this code?
add this as another expression
You try with function Dimensionality() (see Guide).
Row TOTAL is Dimensionality() 0, etc.
if(Dimensionality() > 0,Image1,sum(.......))
Regards
It does not work, Another expression ads another column and also changes total to images