It depends on the desired outcome. Are you just trying to show Alabama and National side by side. If so, it may be easier to create the view on the same worksheet. One way you can do this would be to use data blending. For example, first go to the Alabama sheet. Duplicate the Superstore data source (right click on it and select Duplicate). Then, making sure that the duplicate source is selected, add Sales to the sheet. If desired, right click on the header and select Edit Alias, and change the name to National Sales. Finally, you'll have to link Order Date (simply click on the orange link next to Order Date on the secondary source).
I have reattached your workbook here.
Hope this helps!