I want to calculate Difference between close-open. value of close should be choosen as --- close value corresponding to last date of stockname (MAX(D)) and open value should be ---- open value corresponding to first date of stock (MIN(D)) .there are different types of stock table . I am unable to fetch this data . Please help me as soon as possible as its really urgent.

Thanku for Your quick reply . I am able to get MAXCLOSE VALUE and MIN OPEN value but not getting difference when apply calculation field if difference its not showing any result . Actually I am very much new to Tableau .

Hi, I am bit confused why we are using Aggregation function sum while calculating the difference . Acc. to me SUM(Max closed ) - SUM(Min Open) it will first calculate the sum of MAX CLOSED then calculate the difference . I am not getting how it works .