Getting the total

[#1]

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

[#2]

bump

[#3]

up

[danieloberbilli]

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

[lucas4bi]

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