5 Replies Latest reply on Dec 3, 2012 9:28 AM by Jonathan Drummey

    Aggregating Sales Data Day to Week

    Jacob Todd

      I have a data set that has daily sales for company A and market sales that is an aggregation of companies A, B, C, D, and E. I am trying to view company A sales as a percent of market sales (companies A, B, C, D, and E) by week. When I create a calculated field by dividing company A sales by the market sales (I am calling this percent of sales) and view this by week Tableau is summing the daily percents (which is useless) instead of summing company A sales then dividing by the market sales and giving the percent of sales for the week. Does anyone know how to get the proper calculation? Thanks in advance!