In Excel, when you build a Pivot table, you can tell the workbook WHERE you want the pivot to live. If we can add the functionality to Smartsheet so we can have multiple pivots per sheet, that would be extremely helpful, because then I can build my dashboard charts from ONE SHEET vs. from MANY sheets.
Happy to discuss further if you need more information.