Regarding OWC Pivottable OWC XP 2002

  • Thread starter Screaming Eagles 101
  • Start date
S

Screaming Eagles 101

Hi,

This works fine to add 2 rowaxisses
ptview.rowaxis.insertfieldset ptview.fieldsets("Order")
ptview.rowaxis.insertfieldset ptview.fieldsets("Article")
This also works fine to hide the details and all totals
ptable.activedata.hidedetails
Set ptConstants = ptable.constants
ptview.ExpandMembers = ptConstants.plExpandNever

Trouble is : I DO want to hide the expansion for Article (no totals needed
directly)
but I DON'T want to hide the totals for 'Order', I would like to see the
Totals immediately.

All by code please.
 

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