Sales Report

Hi there, 

I am building the sales report to get the sales data from posting date in cell D5 and by customers name in cell D13. The formula works but it takes hours to run the report. Please kindly suggest any solution???



=@NL("Sum","Value Entry","Sales Amount (Actual)","Posting Date",$D$5,"Sell-to Customer No.",NL("Filter","Customer","No.","Search Name",$D13),"Item No.",NL("Filter","Item","No.","Item Category Code",$E$8))/1000

1 comment

Please sign in to leave a comment.