This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I want to output several outputs to the same excel file. With the output tool, I'm able to name the various tabs using .xlsx|||Tabname syntax. How to I achieve the same effect using the render tool such that I can have a pretty excel output with nicely named tabs?
That worked, thanks. I'm now using two fields (one for the file name, i.e., one for each quarter and one for the tab name) and group by both. That should hopefully give me a file for each quarter with the nicely formatted tables in correctly named tabs.