Date order in Pivot Table

A

Alain Boucher

Hello, I display in a ActiveX a pivot table from a Cube.
My problem is the following:

I can show the sale of the company by week, but the date
order is from sunday to saturday, it must be from monday
to friday... How can I change this... The data that I got
from the DB is fine, It send my monday first but for some
reason Excel change it a the display time.

Thanks
 
A

Alvin Bruney [MVP]

you will need to disable time scaling on the axis in question. time scaling
is on by default. search the help file for timescale
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Retrieve member values for filters in OWC pivot table 0
VLOOKUP a Pivot Table Filter 0
week numbers 7
SUM & OFFSET & PIVOT TABLE?? 0
Using a Date and corresponding weekday to pull amounts 1
Excel 2007 pivot table using analysis services cube as data source 0
weekday in pivot table 4

Top