11 Replies Latest reply on Nov 17, 2016 4:37 AM by Luciano Vasconcelos

    Top N for Nov fiscal year

    Kahv Jiv

      Hi,

      I have to create dashboard for Top N products by sales. I have year parameter and Top N parameter.

      My year parameter will only populate the sales for Top 5 products for year selected and selected year -1. My fiscal year starts from Nov.

      As of now my year selector is populating all the values of years rather than populating selected year value and selected year -1 value.

       

      Also please note when user selects FY13, values display should aggregate data for NovFY12, dec FY12 and Jan to Sept 2013.

       

      Can someone tell me how to do it. worksheet attached.