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 Sub-Total" which is computed using Sub-Category.
Ryan Blank wrote:
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.
So in 2018 Bookcases contributed to 13.94% of total Furniture sales.
Hope this helps.
SuperStore Test Book1.twbx 2.4 MB
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.