I am trying to format a chart where the data axis is a dollar amount that ranges from the $100K's into the $1M's. However when I try to format the axis using the 'number format' within the chart expert, when the number goes beyond the number $999K and hits a million - the number format remains...
I am trying to calculate a monthly average of sales based on territories within a cross tab. Does anyone have any idea how to do this? I have tried the simple fix of changing the summary from sum to average, but the numbers are totally off.
Below is an example...
2/2002...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.