2 Replies Latest reply on Sep 6, 2019 1:36 AM by Rahul Raman

    Sales Transaction Data Visualization

    Kevin Chew

      Hi,

       

      I have two CSV files.

      1. Accounts
      2. Sales Transaction

       

      In accounts there is a column called Account ID which will be linked to Sales Transaction's Account ID.

      Each Sales Transaction will have a sales amount.

      So 1 account will have many Sales Transactions. How do I show a total sales per account in visualizations?

       

      E.g. Account Hollander have 3 Sales Transaction

      1. ST1 has sales amount of USD30.00
      2. ST2 has sales amount of USD50.00
      3. ST3 has sales amount of USD10.00

       

      If I put Account Hollander and Sales Transaction as rows. I will have 3 separate Sales Amount.

      I would like to see Account Hollander has a total sales of USD90.00