9 Replies Latest reply on Jan 13, 2017 1:02 PM by Stephen Rizzo

    HOW TO SUM ON A SPECIFIC VALUE ACROSS MULTIPLE DIMENSIONS, HELP!

    Chris Bell

      I have a data set that has transactions with a Buyer, Seller and Volume of the transaction. In certain cases A may buy from B or B may sell to A or A may buy from C....etc. etc.

       

      Is it possible to show a bar graph with the amount of volume that A has bought and sold. I can easily put it into text table matrix with total, but woudl like a simple bar chart that show total volume of A whereby they were either a Buyer or Seller. Buyer and Seller are two seperate dimensions.

       

      See attached workbook.

       

      Thank you,

      Chris