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:



      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