5 Replies Latest reply on Jan 10, 2017 6:43 AM by tushar.m

    Year and Month Calculation



      I've attached a workbook file. It doesn't contain complete data for all the years. Now, I want to create a view with year and month drop downs.


      But the requirement is if I select particular year it should only show the months for which I've the data not all the 12 months.


      For example, If the year 2012 contains data for all the months so drop down should show all the months and if I select 2013 and if it contains data for 4 months so it should the name of months accordingly.


      Any ideas guys?