Formula for selecting first row of table on each page in pdf

Hi,

Is there any rule/formula by which can we modify (for example apply font in red) first row of table on each page in pdf?

In picture bellow I am looking for way to modify just rows marked in red:

I am looking for way to do it dynamically (if I don't know how much page rows we have on each page).

Is there way to do it in Alteryx?

Reporting

Tips and Tricks

Accepted answers

jrgo

@new_user,

Yes, you're right... that would only work on the first page; my apologies.

Here's another option... determine how many records are populating in each page before it breaks and create a formula that will output a value that would attribute the record identifying it as the first row.

In my example, it was populating 64 records so my MOD expression shows MOD([RecordID], 64). The MOD of 65 (the 65th record) is 1, which is when it know it'll be the first record of the new page.

Depending on how many records you determine, you'll adjust this value in the expression. The workflow I attached has a separate Formula tool that shows you what the MOD function is outputting for reference.