Re: sort totals on multiple dimensions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I think you have to run a custom MDX expression to get this to work because it isn't on by default and I haven't seen anything similar in the object model that would provide that type of functionality.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------


"Joe" <Joe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:F5D517F2-852A-4234-8E2D-09B2B18B18C7@xxxxxxxxxxxxxxxx
Hi all,

Does anyone know how to sort a total on multiple dimensions?
I’m using owc 11.

Suppose you have a pivot table with 2 dimensions called “customers” and
“stores” with a measure called “sales”. Both are in the pivot grid and can
be drilled into. If you sort on the total, it will sort it on the right most
dimension, so the inner expanded items are ordered, but the outer collapsed
ones are not.

The method I’m using is:
Dim ttl As PivotTotal
Set ttl = PivotTable1.ActiveView.Totals("Unit Sales")
PivotTable1.Select ttl, ttl
PivotTable1.Commands(2031).Execute 'descending
PivotTable1.Select Nothing, Nothing

I didn’t have luck with the SortOn function of the fieldset.field, I
received an error message on it – something about method not found.

End result: I want dim1 sorted by total, then dim2 sorted within dim1 by
total.

Any help would be appreciated.

Thanks,
--Joe

.

Relevant Pages

  • Re: sort totals on multiple dimensions
    ... the .SortOn and .SortDirection works, it was just a matter of syntax. ... Does anyone know how to sort a total on multiple dimensions? ... Dim ttl As PivotTotal ...
    (microsoft.public.office.developer.web.components)
  • Re: sort totals on multiple dimensions
    ... but I was hoping to do this with the owc and not ... Does anyone know how to sort a total on multiple dimensions? ... Dim ttl As PivotTotal ...
    (microsoft.public.office.developer.web.components)
  • sort totals on multiple dimensions
    ... Does anyone know how to sort a total on multiple dimensions? ... Dim ttl As PivotTotal ...
    (microsoft.public.office.developer.web.components)
  • Re: Getting out of this world?
    ... maintaining the Universe until we showed up. ... Universe's Big Bang was a much larger version of the sort of QM ... 'fundamentals' as dimensions themselves, much less chemical elements. ... just have nothing we can label 'physics' to describe them with. ...
    (rec.arts.sf.science)
  • Re: Getting out of this world?
    ... That was just sort of my placeholder for technobabble that might be ... you are discussing science in science fiction on a newsgroup about the ... uncertainty in the measured momentum of a particle must be greater ... higher dimensions as well, you might be able to reduce the uncertainty ...
    (rec.arts.sf.science)