If you save a sectioned report as HTML and choose the “section by section” option, the sections are saved in separate HTML pages numbered from 0 (i.e. 0.htm, 1.htm, etc.).
In wanting to link to these sectioned pages from another sectioned page, you need a way to correspond the link value to the number of the page. Assuming the sort of the values in the linking page is the same as the sort of the sections you wish to link to, this would be the linenumber() function corrected to start at 0.
A problem occurs, however, when the linking report is sectioned, instead of all in one table. When sectioned, you cannot use contexts on the LineNumber() function to force it to continue across sections.
Instead, use the aggregate function RunningSum() which can take a context change.
Then, do a RunningSum() of the count of the objects.
The link, set to read as HTML in the cell formatting, looks like this:
Where Link2=(RunningSum(Count(<Business Unit>) In (<Division> ,<Business