O
Orlanzo
Hi All,
I've created a pivot chart in Access 2003 based on a query. The chart
displays a dollar amount for a given report date. I do not need to aggreaget
the data. Therefore, I've enabled the "Plot detail Records" option on the
"Data Details" tab in the properties dialog for the Chart Workspace object.
The issue I'm seeing is the dollar amount is much greater than expected.
If I disable the "Plot Detail Records" option, the data is displayed as
expected. But, the legend shows SumOf...xxx... and SumOf...yyy... when it
should show X and Y.
According to the information I've read, when using the "Plot Detail Records"
option no aggregation of data should be performed. What am I overlooking?
Thanks,
Orlanzo
I've created a pivot chart in Access 2003 based on a query. The chart
displays a dollar amount for a given report date. I do not need to aggreaget
the data. Therefore, I've enabled the "Plot detail Records" option on the
"Data Details" tab in the properties dialog for the Chart Workspace object.
The issue I'm seeing is the dollar amount is much greater than expected.
If I disable the "Plot Detail Records" option, the data is displayed as
expected. But, the legend shows SumOf...xxx... and SumOf...yyy... when it
should show X and Y.
According to the information I've read, when using the "Plot Detail Records"
option no aggregation of data should be performed. What am I overlooking?
Thanks,
Orlanzo