Greetings,

Trying to determine the best course of action to get the results I need. Is it possible to use calculated field/item to create a field in my pivot table to do the following:

Take number from Jan 2017(column b) and subtract it from Jan 2018(column c), then multiply it? I am trying to create a PivotChart that would show 2017 vs 2018 usage and then create a secondary axis for savings. The calculated field would be the savings part. If so, I'm not entirely sure how the formula would look like.

If this is not possible in a normal pivot table, I'm guessing I need to use powerpivot? Thanks for the help.

forum post.PNG