How to display the Pivot Table entries in Descending order?

W

Wes Brooks

Hello expert,

I have a crosstab query listing out the data like these:

Row - Document Types
Column - Stamped Date in 9999/99/99 format
Contents - Count.

Now the Pivot table display the dates from the oldest dates to now (from
left to right). But I would like to present the the latest date first. But
I have tried to put DESC on the query but it didn't work. The dates are
still displayed from oldest dates first.

Please help.
 

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

How to display zero value in blank fields of Cross Tab query 0
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1
pivot table help 1
Report sorting function 2
sorting dates in a pivot table 1
changing a calculation in a pivot table 0
Display Dated memo field subform in descending order 3
MS Access 2010 pivot table as subreport 0

Top