Impossible layout with Pivot?

  • Re: Impossible layout with Pivot?

    Howdy. Probably not the approach you want or need. But you can get close by adding two columns to your original data:

    Column E, labeled in E1 as Count

    Cell E2


    Column F, labeled in F1 as Disc Total

    Cell F2


    Copy both down, then increase the data base by changing through the Wizard to include E1:F11.

    Then move those two items to be additional rows in your pivot.

    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt

    Old, slow, and confused - but at least I'm inconsistent!

    (retired Excel 2003 user, 3.28.2008)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!