1 Reply Latest reply: Aug 4, 2017 7:57 AM by Sunny Talwar RSS

    Current Year vs Prior Year (YTD)

    Dale Pinn

      I have created a display which shows a tree map for the current year, and another separate tree map for the previous year (YTD).

       

      So if I choose months 3 - 5, it should just show the information relating to those months in the tree maps.

       

      For the Current Year it works perfectly. The measure expression is as follows:

       

      sum({<TransactionType={'Month_CCV_Rands'},FinancialYear={'$(v_Monthly_Current_Financial_Year)'}>}Amount)

       

      But for the Previous Year (YTD) it seems to ignore the selection, even though the months fall within the data available. The measure expression is as follows:

       

      sum({<TransactionType={'Month_CCV_Rands'},FinancialMonth={"<=$(v_Monthly_Current_Month)"},FinancialYear={'$(v_Monthly_Last_Financial_Year)'}>}Amount)

       

      Is there a way to have the best of both worlds where by default it shows YTD and then upon selection it will change accordingly?