8 Replies Latest reply on May 2, 2018 1:14 AM by naresh.suglani.0

    Percentage calculation of product sales as a percentage of total sales?

    naresh.suglani.0

      Hi all, I've attached an example excel file. I need to calculate the % sales of each product in the "Product Name" column based on total sales which are in the "Sales" column.

       

      I have included a pivot table showing how the % breaks down. The data file contains a snapshot for week 15 and year 2018, but in the database I'm using, all weeks and years are present so would I be able to filter on week/year in the resulting tableau workbook?

       

      Thanks in advance.