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
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)

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

      Johnmatta,

       

      Instead, you may drag the original measure to Tooltips.