Straight Table Row Count

[Johnnyg248]

Trying to put row count of  straight table into title

How do I get the row count to be what is actually displayed in the straight table

I tried putting the following

='Query Results (' & (Count(email)) & ' Rows )'

If I export the straight table to excel it has 20654 records (not including the header row)

However

Query Results (1211 Rows) appears in title

Not sure where 1211 is coming from

[bharathadde]

Can you share your Excel File

[rwunderlich · Accepted solution]

You will need to specify all the dimensions of your table as a concatenated string and use distinct. 

Count(distinct email & date & name)

assuming email, date, name are your dimensions.

-Rob

[Johnnyg248]

Listing all dimensions  within the count(distinct) did the trick

Thanks!