11 Replies Latest reply: Aug 4, 2016 6:15 AM by Sunny Talwar RSS

    Pivottable to diagram (rangesum)

    André Kabalkin



      I have two problems with the visualization of a forecast - diagram.

      The first one:

      In the pivottable everything is correctly. Here I'm using following formel:

      Rangesum(Before($(vAVG)/10 ,0,ColumnNo())))


      In the diagram I'm using this formel and it shows me only the exist months:

      if( Month<month(Today()), sum( $(vStd)),

      Rangesum(Before($(vAVG) ,0,ColumnNo()))



      The second problem, if I set the filter on Technology, for example "BI", then I get no values for the future month in diagram and also pivottable.


      Can you please help me.