Hi all,
The attached picture below is an example created in excel to mimic the behavior I am looking to accomplish within NetSuite.
I am looking for some help on how to accomplish a summary saved search and print template. In the picture below, col1-4 are all achieved through summarization. However where this gets complicated is with cols week1-5. Our data needs to be summed by week over a given date range, whether that is month by month, or quarterly, and then have that data be a column within our print template as shown below.
Not fully sure if this can be accomplished natively within NetSuite, any help is greatly appreciated!