When you need to filter both start and end, you need to pivot data source.
From edit data source
and so on...
For year and quarter, I think you may be able to use Tableau's FY function, but totally not sure and that's different topic.
Date_Pivot_SM_10.4.twbx 67.4 KB
Thank you for your help but I am totally confused. I don't need help with the FY calculation. I have that, and must use what I have because my data is massive and is refreshed daily from a server that I do not have access to. When refreshed it remove the tableau FY.
Now for my real issue. I am trying to duplicate column G and column I in excel while keeping the Tableau column set to FY Created and Month Created.
If this is what you sent me, my apologies, but I don't see the results.
Sorry I don't understand what is your issue.
Could you illustrate something.
Issue 1. In the excel attachment, I need a calculation to give me the results of column G. While the column area in Tableau has FY Created and Month Created as in Sheet1.
Issue two. a chart that has the same results that I am showing in excel column I.
This is the ultimate goal. But in excel I need the calc from column G to create a calc for column I.
Hope this explains it. I just want tableau to do the same calcs as I have in excel.