pivottable

[#1]

Hello everyone,

I encountered a problem, I would like to have your helps.

I have a simple table as shown below (Table 1)

Ressource	year	Amount
AA	2008	100
AA	2009	200
AA	2010	150
BB	2008	100
BB	2009	80
BB	2010	70

thanks for your helps

table1

I sould present the data in a pivot table (Table 2).

2008	2009	2010
Ressouce
AA	100	200	150
BB	100	80	70
TOTAL	200	280	220

but I have to apply a condition in my table:

so if my amount is above 100, I display the number, but if it is less than 100 I juste display "No display" and also for the total line(table3)

2008	2009	2010
Ressouce
AA	100	200	150
BB	100	No display	No display
TOTAL	200	No display	No display

[#2]

Pls find attachment....

Regards,

Antony.

[#3]

Hi, please find attached.

[#4]

pls ignore my above attachment... attached the new one..

Hope it works for you....

Regards,

Antony.

[#5 · Accepted solution]

Hi,

See the file.

Succes!

[#6]

thanks for your replys