SET ANALYSIS

[#1]

Dear Team, I have a table like Name , Date, sum(orders) . i want to create on more expression in the Table which sum(orders) - MIN date sum of Orders example given below:

Client	Date	Orders	Result
A	20-Apr-14	100	0
A	21-Apr-14	150	50
A	22-Apr-14	200	100
B	1-Jan-14	50	0
B	2-Jan-14	100	50
B	3-Jan-14	200	150

In the above table result column is the difference ( the difference in future may be in % or other formula also)  of the RED, Clientwise.

[aveeeeeee7en]

Hi

Try this Expression:

SUM(Orders)-SUM({<Date={'$(=MIN(Date))'}>}Orders)

Regards

Av7eN

[#3]

try this ,

sum(ordres)-firstsortedvalue(orders,date)

[#4]

order is not datewise single record. i required to use sum()

[#5]

Dear Sir,

i already told before the formula u have given work perfectly fine, when the date is not a part of the table Column,

when i add the date as a column into the table the above formula get fail.

please find screen shot for same.