8 Replies Latest reply: Aug 3, 2017 7:42 AM by Alison Cooke RSS

    Pivot Table Column with Multiple Fields

    Alison Cooke

      Hello Everyone,

       

      Sorry for the bad discussion title, I wasn't sure what name to give it.


      Anyway, I would like to make a table that looks like this:

      Screenshot (69).png

      Where, for each quarter, there is a column for Actual, Budget and the Variance.

      The only difficult is that Q1 Project Budget, Q2 Project Budget, Q3 Project Budget and Q4 Project Budget are all different fields.

       

      How could I make so that, depending on the Quarter, a different field and thus a different quarter budget is displayed.

       

      I tried to use the following expression:

       

      Screenshot (72).png

       

      But that's not quite right.

       

      Does anyone have a good idea?

       

      Thank you in advance,

      Alison