Hi jplumsdaine22, thanks for your comment. To your points:
Creating an index or view --
I've actually done this for the part of the query that all 3 queries share. Without going into detail, I won't be able to store 3 views, which would allow me to store the 3 full queries.
Combining three searches into one --
This is exactly what I'd like to do, but my combined query exceeds the character limit. That being the case, my new plan is to:
1) Run the 3 queries in 3 panels
2) Tokenize the "Total" row from panels 1 and 2
3) Append the tokenized rows to panel 3
I outlined my new plan in response to the comment below, but I'm stuck on steps 2 and 3. If you have any insight, I'd really appreciate it!
... View more