I have 4 Questions all pertaining to creating PivotTables:
1. What is the number system for when you use the setNumber(int) method (type PivotField)?
2. On my pivot how do I change the Data source from the default (sum) to (count)? Attempted to follow
http://www.aspose.com/docs/display/cellsjava/Customizing+the+Appearance+of+PivotTable+Reportsv
guide, but it uses setSubtotals method which doesn't work with particular pivot.
3. How do I have my Pivot ordered by a Row?
4. What method/class type can I use to get an entire reference of all the data. (e.g. =Sheet1!A1:W900)?
Most of my code to create this was taken from guide on how to create pivot.