Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
I think you have to provide some more info.
Expressions that you use.
What and how you load.
Hi Jai,
Use 'Pivot Table' with the 'Timestamp' as dimension and 'Sum(Sales)' as the expression.
Regards,
Sri