3 more dumb Excel questions

W

walt

#1. I have retrieved data from an Analysis Services cube
into a pivot table. The first column of my report is Year
Id and I have limited the data to year 2002. The second
column is department and I have limited the data to Dept
90. The next column is a list of stores and the final
column is unit sales for each store. I am using field
settings, advanced to sort the stores by descending sale
units. The problem is this: If I include all the stores,
the correct result is produced. If I only ask for the top
25 the result is different from (but close to) the first
25 lines of the listing when I include all stores.
Likewise, asking for the top 10 does not produce the first
10 lines from the top 25 listing. Finally I tried the top
3 and got a different result than the first 3 lines of the
top 10 listing. Has anyone seen this before?

#2. Another excel report generated from a different sales
cube. I have a column on the report that represents a
dimension with 3 levels from the cube. When I drill down
from region to district to store, I dont seem to be able
to tell excel to sort the stores by sales units regardless
of the region and district hierarchy. It only sorts by
store within region and district. Does anyone know a way
to tell excel to ignore the higher level of the hierarchy
and sort just by store?

#3. (dumbest of all) When drilling down through a
hierachy in a pivottable is there a way to tell excel to
drill down to the lowest level of every dimension? For
example I don't want to click on 8 districts for each of 4
regions and then click on 10 stores for each of 32
disricts to get down to the lowest level. There's got to
be a shortcut.

Thank you for your 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

Top