8 Replies Latest reply: Sep 22, 2018 8:34 AM by Vladislavs Batalovs RSS

    Using p() in set analysis when having Multiple Tables and 2 Month Fields

    Vladislavs Batalovs

      Hi Guys,

       

      I am a little stuck here and hope you can help me out with a set analysis issue.

       

      I would like to incorporate Budget and Profit figures in one table in the front end of the app using set analysis.


      My Data model is as below:

      dmins.PNG

       

      What I want to do is to have a table like this, however as you can see the Budget figures give me a sum for the whole year in every month line:

      dmins 2.PNG

       

      In my set analysis I have the following and technically it should work, but it doesn't:

       

      Sum({$< [Budget Year] = p(Year), [Budget Month] = p(Month)>}[Budget])


      Any advice or ideas would be very much appreciated