4 Replies Latest reply: Apr 10, 2013 6:44 AM by Luca Cavallari

# Getting the total

Hi All,

I need to get the total of the values in my table. please see the sample table:

 Month Year Feb 2013 Feb 2013 Feb 2013 Mar 2013 Mar 2013 Mar 2013 NO 4000 4000 4000 4000 4000 4000 Final Category CODE FILLED BULK Total FILLED BULK Total Beginning Balance 1000 10000 11000 75527.00 271,601.00 347,128.00 Transfer 500.00 200.00 700.00 51201 3434 54,635.00 Gain 600.00 24,453.00 25,053.00 23232 564654 587,886.00 Loss 2004.00 5,949.00 7,953.00 32321 3123 35,444.00 Purchase 62423.00 239,999.00 302,422.00 2312 343242 345,554.00 Total 75527.00 271,601.00 347,128.00 184593.00 1186054.00 1370647.00

The red fonts in march are the total from feb. I need to set the beginning balance of the next month of the totals.

feb beginning balance is already given.

Thanks,

Donna

bump

up

• ###### Re: Getting the total

Dear Donna,

Could you add a qvw.-file, so that is easier to see the input and what you are looking for.

Kind regards

Daniel

• ###### Re: Getting the total

Given that you have 2 expressions: FILLED as first expression and BULK as second, try with something like this:

If( Category='Beginning Balance',

if(Columnno(Total)=1, CALCULATE GIVEN VALUE,   //check the first column with the given value to return (feb)

before(total bottom(total column(1) ) )     //returns the bottom cell calculated in the previus dimension (total)*

)

)

change column number for each new expression you want to check, for BULK it would be "column(2)" and ColumnNo(Total)=2.

*total must be a category value, it doesn't check the cell created using the "partial sum" checkbox.

Luca