poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Blake Watson <blake.wat...@pnmac.com>
Subject Re: Pivot tables
Date Thu, 22 Mar 2018 17:05:50 GMT
Good to know. I can enforce a certain discipline on the users like "You
must use a table", so there's that.

On Wed, Mar 21, 2018 at 3:45 PM, Greg Woolsey <greg.woolsey@gmail.com>
wrote:

> >
> > I'm gonna hope this comes in a lot lower on the priorities than some
> > functions I need to add. =P
> >
>
> I hear that.  When I first looked into it, I got very creative in finding
> ways to do what we needed without using Pivot Tables :)
>
> In the past, the only time I used them with POI was through a template
> built in Excel where the pivot referenced a full sheet of data, and I could
> update that sheet with however many rows of data the specific instance
> needed. It worked specifically because I didn't have to touch the pivot
> table structures at all.
>
> If your pivot table references an Excel structured table, those are also
> not as bad to manipulate, even changing the number of rows.
>



-- 

*Blake Watson*

*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message