Give a selected field a continous number in a crosstable

[tinkerz1]

Hi,

I have attached a qvw that is based on a cross table, I have selected 3 ID's and in the table next to it you
will see in Field1 'spacer'.

What I would like so to place a continous number in Value1, so when I export into excel I can place a page break every 3 spaces.

But I need a number in Value1 to be able to do this, therefore.

Or I simply need ID2 to run 1 to 3 or another ID column

Thanks

Message was edited by: Neil Woodham Apolgies for my tardy response. this is what I was thinking.

[daveamz]

You can limit the subset in variable to those records that have Value1 = D2 or Value1 = D3:

=Concat({<Value1 = {'D2', 'D3'}>}DISTINCT ID2, ',')

[tinkerz1 · Accepted solution]

HI,

I managed to find a solution.

First all other 'if' statments had to be moved into the load script.

Then when I used Rowno() it worked.

=

if(Value2='Spacer',aggr(RowNo(),ID2a))