I have a pivot table with three fields on Opportunity table. Account Industry, Opportunity Stage and Amount. Now I need to group the Amount i.e. show the total amount based on Industry as well as Stage. I could accomplish this through SAQL but the amounts are being shown as sub totals as rows ie Total amount as Stage and Total amount for Industry. I would like that to be shown as a matrix report with total amount of industry as a rightmost column after amount and total amount of stage as a row in the bottom most row. SAQL I used was from https://www.youtube.com/watch?v=vkuQ5PIDiIQ.

This is working however the client requirement is to show them as amount based on industry as a column and not the row.

What I am getting


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.