Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Can you share your Excel File
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
Listing all dimensions within the count(distinct) did the trick
Thanks!