first row in Pivot table

[#1]

Hi,

Please i want to make condition on the first row only in pivot table

when i use the RowNo()=1 to make the condition

each first row in the dimension dividing the table apply the condition

i don't want that

i wnat only the first row in the whole table

how to do it??

for example

this is the condition for column x

if(RowNo()=1,20,30)

this is the table

productName,b_Number,x

Test1,1,20

Test1,2,30

Test2,1,20

what i want is that Test2,1,30 not 20

Hope the problem is clarified

[swuehl · Accepted solution]

Hi,

try RowNo(total).

Regards,

Stefan

[#3]

Thanks Stefan so much

it works