Forum Discussion
Solved
Creating a Matrix format in the Query Editor
Hi, Some Background: I have to work on figuring out the movement of opportunities within our Salesforce along the sales stages setup in the system (negotiation, PO, Business Lost...). The thing ...
You can use "GROUPBY" operation before doing pivoting to achieve waht you are looking for.
If account name was the same lets say there is "A" and the amount is 1000 in Value Validation and another time "A" and the amount 4000 in Value Validation how do you connect both of them?
or in the case where an account has one opportunity at Value Validation and another at Business Lost, how do you connect them?
You can use "GROUPBY" operation before doing pivoting to achieve waht you are looking for.