While I think the above works, I changed the specifics of the question a bit to better reflect my issue.
I added a new row to the data called "sub segment". The goal would be to display the category sales share for both "Classics" (Category) and then the sub segment of "Classics" called "1200cc".
Please let me know if that is clear and if it is possible with the calculation you provided. I tried playing around with it and adding a sub segment field but it is not doing what I intended.
As always, I appreciate the quick response and brilliant input.
I think you will be able to get that worked out from what i sent
Hmm I am still having difficulty display the correct numbers as the file I
am working with has multiple categories and sub segments. How would I go
back identifying the ones I want to display?
On Wed, Feb 14, 2018 at 6:12 PM, Jim Dehner <email@example.com>