I have an Ad Hoc report that I need to state how many rows are included in the file so that the user knows if it will exceed the max rows that Excel can handle (something like 1.048 m I think).
I tried creating a variable called vGetFields =GetFieldSelections(_Dimension, ' & ',100)
and then a Text Box: ='Number of Lines ' & Count(distinct $(vGetFields))
but it is not working as I intended. For example, if the Dimensions I have selected result in one row of data, it should read 1.