2 Replies Latest reply on Nov 8, 2018 1:12 PM by Ryan Blank

    Calculate Percentage of Subtotal by Category

    Ryan Blank

      Hello,

       

      I'm trying to create a calculation to get the percentage of the subtotal for each category.

       

      I have attached a sample copy of the Superstore data with a basic table to illustrate. What I'd like to see if % of sales of each category listed on the sub-category line. So for instance, Bookcases would be 22.7% of Furniture sales for 2018.

       

      Is there a way to do this via creating a calculated field instead of using quick table calculations? I ask because my actual project is more complex with several unions.

       

      Thank you,

       

      Ryan