first row in Pivot table

Wed, 13 Jul 2011 13:32:47 GMT

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 — Wed, 13 Jul 2011 14:12:16 GMT

Hi,

try RowNo(total).

Regards,

Stefan

Wed, 13 Jul 2011 14:51:30 GMT

Thanks Stefan so much

it works

topic first row in Pivot table in QlikView