Question aggregate

[marcel_olmo]

Hi guys, if I have a table like this :

Date	Number
20/01/2012	2
20/02/2012	2
20/03/2012	1
20/04/2012	3
20/05/2012	1
20/06/2012	1

How could I get a table like this with set analysis ?

Date	Number
20/01/2012	0
20/02/2012	0
20/03/2012	0
20/04/2012	0
20/05/2012	0
20/06/2012	10

Regards, Marcel.

[#2]

Hi Marcel

Does this fit your needs?

best regards

Chris

[salto]

No way! Values are in the first date

[marcel_olmo]

Thanks Brian! It works well in this table. But as I see, it works depending on the Id on the table. What I mean is that in the table I haven't explicitly the ID, and there are more fields to take in count to get the correct sum.

Imagine there's ID, ID1, ID2, ....IDN.

How this will work with a lot of related fields without needing to add this fields into the table?

Many thanks in advance!

[bdunphy]

as an example - I use this calculation to give a stock total for Item Subgroup within Customer.

The table itself has approx 10 dimensions. It does not matter how many.

I just check it the row below is a new customer or a new Item Subgroup and if it is - I display the total for that Customer, Item Subgroup.

Try it with your data. or if you can - post a sample qvw

If(

MaxString(Customer)

<>

below(Total MaxString(Customer))

or

MaxString([Item Subgroup])

<>

below(Total MaxString([Item Subgroup]))

,

Sum(Total<Customer,[Item Subgroup]> [Total Stock Wgt]),' ')

[marcel_olmo]

Thanks Brian! You're very helpful.

But it still don't work for me.

In the QV document you will have a table with my "current result", my "desired result" and another one with what I'm trying based on your formula-

This is a sample of what I'm doing. Could you tell me what I'm doing wrong?

Regards, Marcel.

[christian77]

Hi Marcel.

I send you a try attached.

Salutes.