2 Replies Latest reply: Oct 27, 2013 11:11 AM by Gysbert Wassenaar RSS

    Conditional Expressions in pivot table


      I need your help. I have a pivot table in which I have to show up the Actual and the Forecast prices for some materials for each month. If I select from the list box the current year, I'll need to visualize the Actual Prices up to the last month (but this is not a problem because the actual prices are loaded until the previous month) and for the next months the Forecast Prices up to the end of the year (but the forecast prices are loaded for entire year). If I select a past year, I'll visualize only the Actual Prices.
      In the attached file you can see the layout I want.
      I was thinking to use Conditional Expression on the Forecast prices and use a condition like Month >= CurrentMonth but I'm very new on QV, so I need your help.
      Thank you