Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
i have table like saleheader,it have salesorderid,salesperson and salessmount and onlinesaesflag
i want to show the salesperson,sum(sales) in table
those who have onlinesalesflag,they all should be come under onlinesales.
i dont want to show their names,all of the sales come under onlinesales.
i.e, salesperson column i would like to show their names(only direct sales) and final row should show the word onlinesales..
thanks in advance