Solved

Access OWC 10 PivotTable align detail summed/calculated fields

Posted on 2006-07-13
2
390 Views
Last Modified: 2011-08-18
Is there any way to change to alignment of the "summed totals" and "calculated total" percentages  in an OWC PivotTable from vertical to horizontal.
           
 What I have is              
                          Sum1            Sum2        Perc Sum1/Sum2  
jan                        1                  2               .5
feb                         4                10              .4
march                    3                  9              .33

and basically want to change it to

                       
                   
jan                 1
                      2
                      .5
feb                 4
                     10
                     .4
march             3
                     9
                    .33
0
Comment
Question by:guilloryt
2 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 17098798
Hi guilloryt,

Move your Column field into the Row area, after month.

Regards,

Patrick
0
 

Author Comment

by:guilloryt
ID: 17099301
OWC Pivot Table control does not allow you do that with "calculated totals".
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now