5 Replies Latest reply: Apr 10, 2014 6:12 PM by Yury Pritzker

# Replacing numbers with images in pivot table, but not totals

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([A]))/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([A],'100'),'qmem://Image Name/100',

if (Match([A],'75'),'qmem://Image Name/75',

if (Match([A],'50'),'qmem://Image Name/50',

if (Match([A],'25'),'qmem://Image Name/25',

if (Match([A],'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

• ###### Re: Replacing numbers with images in pivot table, but not totals

try using column function like

if ( column(1)<20 ,'Image1,

if(column(1)>40,'Image2','Image3')

Hope it helps

Sri1

• ###### Re: Replacing numbers with images in pivot table, but not totals

were would I use this code?

• ###### Re: Replacing numbers with images in pivot table, but not totals

It does not work, Another expression ads another column and also changes total to images

• ###### Re: Replacing numbers with images in pivot table, but not totals

You try with function Dimensionality() (see Guide).

Row TOTAL is Dimensionality() 0, etc.

if(Dimensionality() > 0,Image1,sum(.......))

Regards