Hello all,

I am trying to create a pivot chart to display predicted versus actual savings based on a month or a timeframe. This chart would also be able to display based on one initiative, multiple or all. It seems that you have to have your data sorted in a particular fashion in order for pivot charts to work.

I have placed screen shots below of the form that I am using. The Predicted and Actual savings fields are currency fields.

The "Entry Date" field only shows the date the info was placed, it changes with every entry so it would not be usable as a filter.  

Any help is appreciated.

Regards,

Joseph