Aggregate the data based on time stamp

Wed, 12 Sep 2012 14:18:59 GMT

I want the data to be aggregated based on the timestamp.

For example:

During

12/08/2012 08:00:00 -----------Product1------------12 sales occured.

12/08/2012 08:00:00 -----------Product2------------3sales occured.

12/08/2012 09:00:00------------Product1------------2sales occured.

12/08/2012 09:00:00------------Product2------------3sales occured.

This means between 7 and 8 12 sales occured and between 8 and 9 5 sales occured.

But when I create a straight table, I get the data this way.

12/08/2012 08:00:00 ---------Product1--------------14 sales occured.

12/08/2012 08:00:00 -----------Product2------------6 sales occured.

12/08/2012 09:00:00-----------Product1----------------14 sales occured.

12/08/2012 09:00:00-----------Product2----------------6 sales occured.

The data is getting aggregating based on products . Can any one help me with this please?

Regards,

Jai

Re: Aggregate the data based on time stamp

whiteline — Wed, 12 Sep 2012 19:56:18 GMT

I think you have to provide some more info.

Expressions that you use.

What and how you load.

Thu, 13 Sep 2012 07:39:20 GMT

Hi Jai,

Use 'Pivot Table' with the 'Timestamp' as dimension and 'Sum(Sales)' as the expression.

Regards,

Sri