I have raw data on order level by monthly, see below table:
|Order||Product Line||Fiscal Period||Grand Total|
|4641096||Mass Spec Life Science - ICR-FT||2012-01||3,120.01|
|4648461||Mass Spec Life Science - ICR-FT||2012-01||1,815.02|
I want to create a dashboard report based on user select "Fiscal period" (e.g. 2012-04), I create different calculated filed:
The report look like below pic:
Can somebody help to let me know how to create the the above calculated fields? Thank you in advance!
Thanks for providing the information above, but it's going to be difficult to answer this question without a packaged workbook. If you have sensitive data, please check out Anonymize your Tableau Package Data for Sharing.