hi Friends/Experts,
need set analysis expression for comparing 4 columns like
Tab 1:- 1)item_no,2)item_name 3)Item_Rank
Tab2:- 1)item_num,2)item_naming 3)Item_Rank 4)item_cost
now i want expression for
sum(item_cost) where item_no=item_num & item_name=item_naming
aggr(if((item_no=item_num and item_name=item_naming),sum(item_cost)) , ( item_Rank))