6 Replies Latest reply: Jan 21, 2016 8:59 PM by Jarven Wang RSS

    sum({<Region=>}Forecast) does not work

    Jarven Wang

      Hi guys

      i have a simlar appliaction like below two table

       

      MonthRegionProdcuctSales
      201510Northaa10
      201510Southaa5
      201511Northaa15

       

       

      MonthProdcuctForecast
      201510aa10
      201511aa15

       

       

      I use Month & Product as the foreign key to link and design a chart as below

      MonthProdcuctForecastSales
      201510aa1015
      201511aa1515

       

      As the above example, when I select "South" in the Region

      201511 data will be lost even I use sum({<Region=>}Forecast)

       

      How to solve this problem when sales include different types but forecast only setting for the month ?

       

      PS In my real case (much more complicated), sometimes it work,but a third measurement (Invoice) will affact by the region