This content has been marked as final.
Show 2 replies

1. Re: Calculate Percentage of Subtotal by Category
ShivaRam Chennapragada Nov 8, 2018 11:19 AM (in response to Ryan Blank)Ryan Any reason why you have "Difference From" Quick Table Calc in your view and not actual SUM(Sales)?
I have cleared the Quick Table Calc on SUM(Sales) which now gives actual sales numbers. Then I created a Calc field that does the "% of SubTotal" which is computed using SubCategory.
Ryan Blank wrote:
What I'd like to see if % of sales of each category listed on the subcategory line. So for instance, Bookcases would be 22.7% of Furniture sales for 2018.
So in 2018 Bookcases contributed to 13.94% of total Furniture sales.
Hope this helps.
Best,
Shiva.

SuperStore Test Book1.twbx 2.4 MB


2. Re: Calculate Percentage of Subtotal by Category
Ryan Blank Nov 8, 2018 1:12 PM (in response to ShivaRam Chennapragada)Thanks Shiva. Not sure how/why I had the difference from calc in there. Probably just me rushing.
This worked perfectly. I appreciate your assistance.
Ryan