help in

[#1]

HI

i have a pivot table with dimension

i am attaching the sample app. please look into it and let me know the suggestions

[#2]

if you are looking for something like this, where the numbers are green or red

you want to expand the expression (the + sign) and go into Text Color and use the following expression

=if (Count(SaleID) > 5, rgb(0,130,0), RGB(255,0,0))

if you want the color of the cell to change to red or green, then isntead of putting the above expression in the txt color property place it in the background color property

[#3]

Thanks Adam

I need to compare for every two years like 2012, 2013    ....... 2013 and 2014 ........ 2014 and 2015 like this

not for the whole years count of sales.

[#4]

ahhh - sorry misunderstood

I think you want to use the same concept using set analyis in the expression of the color

[gsbeaton]

Hi,

You can use the Above() function to get the value of the cell above, which will allow you to determine the text colour to apply.  Something similar to this should work: if (above(Count(SaleID)) > Count(SaleID), red(), green());

[#6]

thanks Adam for the response

i am trying it out but not success

[sinanozdemir · Accepted solution]

I came up with this atrocious expression, let me know if this works for you:

[#8]

have you tried the expressions Sinan sent?

[gsbeaton]

Hi Sinan,

Well if it works it's not wrong

However, if there is a lot of data, that expression is going to run very slowly.  Using the inter chart function Above() will allow you to get to the value in the cell above without having to do a whole load of recalculations.

George

[#10]

Hello George

Thanks for the response but unfortunately above() is not near to the requirement,