Hi, I created a saved search that generates a price list for our customers. For each sku we have 3 records: 1. base price from the parent sku 2.base price from child A ( for custom over a specific size). 2.base price from child B ( for custom under a specific size).     SKU   SIZE                   PRICE   2118.  small/large         $10 2118.  custom A            $20 2118.  cusomb b           $30   Is there any way I can Pivot the data so the output will be like this :     SKU   SIZE                   PRICE.   price A.  price B   2118.  small,large.      $10.        $20           $30 Thanks in advance.

Did you try using SuiteAnalytics Workbook pivot feature?

you can use a formula and case when statement that puts the price in the correct column. You will then need to use the summary fields on the search to group by client and max by prices.

Hey K! NetSuite has a Pivot Report feature for Saved Searches, still Beta but it works.  To get the feature check the following steps:  1. Go to Customization > SuiteBundler > Search & Install Bundles 2. Click Advanced. 3. Fill in the following • Keywords = 17447 • Location = Production Account 1. Click Search 2. It should give you a result showing the Name, Bundle ID, Version, Company Name, etc. 3. Click on the Name "Pivot Reports BETA" and it should give you the option to install the feature. 4. Click Install button to install the Bundle. 5. A message will popup saying "By installing this SuiteBundle you are giving the solution provider permission to install future updates in your NetSuite account at any time. Do you want to proceed?" 6. Click OK. 7. In the Preview Bundle Install button, click on Install Bundle button. 8. A message will popup saying "This will install the bundle and all its objects (custom records, forms, scripts, etc.) into your Account. Are you sure?" > Click OK. 9. Click Refresh button until Status changes from "Pending" to a green check mark. 10. Once you see a green check mark next to Pivot Reports BETA bundle,the Pivot Report button should immediately be available in the Saved Search. Hope this helps you