Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
Trying to create an analytics report to show the sales transactions for sales rep and their teams
Hi Everyone,
I was trying to create an analytics report from a linked dataset to show the information of sales transactions of a sales rep and the team which they belong to.
I had 2 data sets. First one showed all the sales transactions and the requirement information and sales rep name. Second data set was of the Sales team (group type data set) that showed the sales rep name and ID and team name. A small snip of the two data sets are shown below.
DataSet 1 : Transaction - Invoice
Data set 2 : Sales team and members
The requirement is to create a pivot table where I can see the list of all the transactions of a sales rep and show which team that sales rep belong to like shown below. However, as you can see Sales team is always showing No Sales team.