How to make calculations on the unselected records in a table

[syed_muzammil]

Hi All,

I have a Table Main as you can see in the example below. I have the lists of AccID,Year and Month on my Sheet. I created a Straight Table with dimesions as AccID and Year. I have Two Expressions , the first one gives me the Balance for the selected AccID , Year, month and this is simple. For the second Expression i want the Total Balance from the first Month of the selected Year to the month selected.

For eg:

if i select Year=2009 AccID=1 and Month = May i shud get the sum of Balances from Jan to May for the year 2009 having AccID =1.

i have tried everything. Any help from you wud be great .

Main:

LOAD * INLINE [
AccID, Month, Year, Balance, MonthNo
1, Jan, 2009, 100, 1
1, Feb, 2009, 200, 2
1, Mar, 2009, 300, 3
1, Apr, 2009, 400, 4
1, May, 2009, 500, 5
2, Jan, 2009, 600, 1
2, Mar, 2009, 700, 3
2, May, 2009, 800, 5
2, Aug, 2009, 120, 8
2, Jul, 2009, 150, 7
2, Sep, 2009, 220, 9
3, Nov, 2009, 250, 11
3, Dec, 2009, 330, 12
3, Jan, 2009, 350, 1
3, Aug, 2009, 450, 8
3, Feb, 2009, 550, 2
3, Jun, 2009, 650, 6
];

Thank u.

[syed_muzammil]

Can anyone help me please.

[martin59 · Accepted solution]

Hi,

Is that you want ?

Hope that helps you.

[syed_muzammil]

Hi Martin ,

Thanks a lot. It fits exactly in my application. Hey where can i find the functions listed in the expression. Like

GetFieldSelections(). Thanks a lot once again.