3 Replies Latest reply on Nov 16, 2016 6:53 AM by Shinichiro Murakami

    Action filter with a Calculated field

    Naveen Vanaparthi



      Please find the workbook attached.


      1st Step: pick a year (e.g. FY 2010), updates top worksheet:

      2nd Step: Click on a month bar (e.g. February), updates bottom worksheet

      3rd Step:Click on a day (e.g. 9, see 1st screen shot below), drills to detail on next screen (2nd screen shot). However, desired functionality and challenge is to capture the value 9 and pass it to the detail screen and limit the detail screen for days <= 9:

      Please let me know any ideas