File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Java in General and the fly likes What data type ie collection or logic to be used for data? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "What data type ie collection or logic to be used for data?" Watch "What data type ie collection or logic to be used for data?" New topic
Author

What data type ie collection or logic to be used for data?

Maki Jav
Ranch Hand

Joined: May 09, 2002
Posts: 436
Hi,


I have a pivot and my pivotTableModel holds data in this fashion...
eg I have a data containing task,Year and month field values


The struture of my PivotTableModel. Below the data is being show in PivotTableModel rows...
it has theses fields
Task         Year Month Values

Issued check                7 => Total checks issued
               2010            4 => Total issued in 2010
                      Feb       3 ==> in Feb, 2011
                      Mar       1 ==> no of checks issued in Mar 2011
               2011            3 ==> Total in 2011
                      Dec       3 == > issued in Dec, 2011


Now I have to show this pivot table

                         2011      2010   Total
Task                   Feb Mar  Dec
Issued Checks      3    1     3         7



How to go about it?

I have a logic which tells me that user has asked for one (or more ) columns on the left and one or more columns on the top

I am havng success to show and also sort values of the left ie values of the task. but the values on the top. If single set of values I am to show. no problem, it is sorting too. but when I have more than that on the top, the top header values stop sorting and also the values against them in the table are not getting put correctly.

Thank you,

Maki Jav

Help gets you when you need it!
Maki Jav
Ranch Hand

Joined: May 09, 2002
Posts: 436
Anyone there to help me with this? What path should I take?
Maki Jav
Ranch Hand

Joined: May 09, 2002
Posts: 436
The main problem could be that

There can be more than one Feb 2011 occuring against tasks that I have not shown. So I need to merge all occurences and show as one Feb 2011 on the x-axis and show other tasks as occuring against it...



Anyone with a suggestion to the problem?
Riaan Nel
Ranch Hand

Joined: Apr 23, 2009
Posts: 160

It's pretty difficult to understand your question as it is.

Can you post a SSCCE?


"The reasonable man adapts himself to the world; the unreasonable one persists in trying to adapt the world to himself. Therefore, all progress depends on the unreasonable man." - George Bernard Shaw
Maki Jav
Ranch Hand

Joined: May 09, 2002
Posts: 436
This is the model with real data from database...

Maki Jav
Ranch Hand

Joined: May 09, 2002
Posts: 436
And I need to pivot it with the structure


Total
2011 2010
Feb Mar Dec
Task 100 (including other tasks)
Issued Checks 3 1 3 7




        Year         Total
        Month
name                value

please see table I constructed in the first post...

Sorry I could not post the table perfectly. It is ugly...


Thanks,

Maki Jav

Maki Jav
Ranch Hand

Joined: May 09, 2002
Posts: 436
I have shortened the data. When you run example, you will see that the System.out.println() statements correctly indicates what data is being picked. I have added one more column "Date". User may decide to chose 3 or even more headers on the top of pivot table!

The end result I want is

List columnTopHeader or even if we take that out, List data be filled with such Vectors or HashMaps/Hashtables that reflect our data

eg
List data/ or columnTopHeader ---
         + --- Year (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
         + --- Year (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
                               +--- Date (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)
                               +--- Date (Vectors/ or other collection)
                               +--- Date (Vectors/ or other collection)
                    +--- Month (Vectors/ or other collection)

or more vectors//collections within vectors/collections as per data requirement.

And in the end I would arrange them

as per user choice after merging similar values... eg for the various names we will have 2011 and also March
so that we will have one 2011 and March in the headers and various names are "ticked" against that

                                                     2011
                                                         March  April
name

BALANCE CONFIRMATION PROCESS        10
.....
.....
CENTRAL BANK ORDER PROCESS            105



The above example shows only a part of table.

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: What data type ie collection or logic to be used for data?