Access OWC 10 PivotTable align detail summed/calculated fields

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
guillorytAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Patrick MatthewsConnect With a Mentor Commented:
Hi guilloryt,

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

Regards,

Patrick
0
 
guillorytAuthor Commented:
OWC Pivot Table control does not allow you do that with "calculated totals".
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.