Hi,

Could you recommend me how better to organize the following:

I have a table in the database,

date !  item  ! sales_amount

I need to compare the sales data for 2 different periods So the result must look like

tems      !      periode 1      !   periode   2  !    vs (periode2/periode1)
--------------------------------------------------------------------------
item1     !      100            !      200       !    2
item2     !        -            !       50       !     N/A

In terms of SQL, it is two queries to the same table but with the different date range

How to put them to the one table considering that the list of items in the results can be different (some items the same, some not)

I think I can do something like that using sql join with subselect but maybe koolreport has something easier

ok. thanks, I will try both ways :-) never used the cube process before so wanna try :-)

Hi, one more question

I followed your recommendation and it is great :-))

But what if the task is a bit more complicated and I have the data like this

date ! item ! quantity ! sales_amount

and i need to have 2 columns for each period sum quantity and sum sale_amount. Is it possible to get with Cube?

I tryed like this but it doesn't work

"sum" => array("quantity","sales_amount")

koolreport is like a detective novel - more interesting with each page :-)

You know

i try like this

->pipe(new SuperCube(array(
               "row" => array("category","name","uom"),
  //              "row" => "category","name","uom",
                "column" => "periode",
                "sum" => array ("quantity","total"),
            )))

And with the commented row (it is like in the documentation) I get only the first column but with the array it works nice same in the "sum".

:-( my mistake

I Love Koolreport!

I can get this table

with just some lines of code. Really cool!