need help in the charts

[alexpanjhc]

Hi

I have a table that has all the historical data,

customer_no,period,balance($)

1,Jan,100,

1,Feb,201,

1 ,Mar,224,

1,Apr,500,

2,Jan,50,

2,Feb,110,

2 ,Mar,330,

2,Apr,500,

3,Jan,60,

3,Feb,100,

3,Mar,70,

3,Apr,80,

so i created a pivot table based on the histrical data.

customer_no/Period	Jan	Feb	Mar	Apr
1	100	201	224	500
2	50	110	330	220
3	60	100	70	80

Now, I want to know that if a customer had a jum of $100 from say Feb and Apr, and I want to know that customer number.

How do I create a table?

notice that I can't create a field in the load for the difference because we could be asking any 2 months that we have a jump of $100.

the result should look something like that.

customer/period	Feb	Apr
1	201	500
2	110	500

How do I achive that?

[maxgro]

[nagaiank]

A sample implementation for the data provided by you is attached. You may devise a solution like this for your actual application.

[alexpanjhc]

Hi NagaianK

Thanks for the reply, but I do not think I understand your solution.

Were you marking all the values greater than 100?

If I look at Feb and Mar, customer 1 should not show in the list.

i do not think thats what I wanted.

Thanks!

[alexpanjhc]

Massimo

Thanks, this is very helpful.
However, the dataset is huge(4gig) for the table and then to create another one to join maybe very costly. I am not sure how to get that part done.

Thank you!