3 Replies Latest reply on Oct 25, 2017 7:27 AM by nagendra kumar

    Display value of last month for Fiscal year

    Kahv Jiv

      Hi,

       

       

      I have a situation where I have to display the value of the last month for the fiscal year selected. My fiscal year starts from nov.So for FY 2015, the value should be display for that KPI should be Oct 2015.

       

      I have mocked up a tableau report.So when the user selects Quantity. It should display the last value for that display year.

      i.e. in this case for furniture, FY 2014 should display 10, FY 2015 should display 8 and so on.(Please note Oct is last month for FY2014 and FY2015 has data only till Aug so it will display last month till date)

       

       

      any suggestions on how to do it..? can someone pls help..?

       

      Thanks in advance!