Hi Everyone,
I have a query set up with data for maintaining a piece of equipment.
There are three strategy fields Strat1, 2 & 3 for example Strategy 1 might be replace it, strategy 2 repair it etc.
These have cost type fields CapEx1, 2 & 3, and OpEx1, 2 & 3
And finally an implentation date field StraDat1, 2 & 3.
I need to display a sumtotal of each cost against time in a pivot chart.
I have managed to get them to plot against one date field but really I need the chart to look at all three and plot against one axis.
I have tried adding all of the date fields to the x axis but it just adds multiple axes and the dates get screwed up.
Any ideas?
Many thanks,
Kev.
I have a query set up with data for maintaining a piece of equipment.
There are three strategy fields Strat1, 2 & 3 for example Strategy 1 might be replace it, strategy 2 repair it etc.
These have cost type fields CapEx1, 2 & 3, and OpEx1, 2 & 3
And finally an implentation date field StraDat1, 2 & 3.
I need to display a sumtotal of each cost against time in a pivot chart.
I have managed to get them to plot against one date field but really I need the chart to look at all three and plot against one axis.
I have tried adding all of the date fields to the x axis but it just adds multiple axes and the dates get screwed up.
Any ideas?
Many thanks,
Kev.
