I have multiple layouts set to sort differently on enter.

One layout, called Pipeline, sorts and shows all records only if they have been quoted.

I'd like to display the number (135) of all quoted records on all of my layouts regardless of how they are sorted.

I've tried using a Count Field and when I'm in the Pipeline layout it shows correctly 135 but once I enter a different layout thats sorted differently it displays the count of records with that layout.

 

Any ideas?

 

Thanks

 

Sorting has nothing to do with this.  It's the "show only" part that is producing the found set.  Instead of showing the found set, show the total record count.

 

You can use a merge variable for this so that you don't have to add a calc field to your schema.