Discussions
Combining datasets into 1 table of a workbook
Hi,
Currently we are combining 3 separate searches offline into 1 excel through V-lookup.
We want to see if we can bring this into 1 SuiteAnalytics report.
The searches are in different area's with different criteria:
- a Item search with criteria like type, product group and name
- a Transaction search with criteria like type, subsidiary, vendor, item, created, tax line - false
- a Project search with criteria like project type, project status, custom record and which is a groupy by summary search
My initial idea was to create 3 datasets and from that create 1 workbook with 1 table where i would combine all 3 datasets.
I now see that if I create 1 table in a workbook that this can only be from 1 dataset.