RE: Pivot in Save search

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.

K

k Rookie Asked on February 25, 2020 in Best Practices.
Add Comment
1 Answers

Hi

There is a bundle I have seen before on the suite app called Pivot Reports BETA is free i believe and if you install in your sandbox and test it for your account and data you might like it.

 

Rookie Answered on October 29, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.