Forum Discussion

Johnmatta's avatar
Johnmatta
Icon for Advocate I rankAdvocate I
8 years ago

wrong TOTALYTD total in waterfall chart

The total column in Waterfall chart is not showing the right TOTALYTD total

 

Need Help

3 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Johnmatta,

     

    You may just use measure below in the Waterfall chart.

    Measure =
[Stock Total] - [Total Forecast]
    • Johnmatta's avatar
      Johnmatta
      Icon for Advocate I rankAdvocate I
      8 years ago

      Thanks Sam, but if I used your suggested measure it will not get the historic balance. For example: stock balance for July should be = Stock Balance (June) - Total Forecast (July)