1 of 1 people found this helpful
Would you be able to share your workbook with us (as a .twbx) so we can see how your calculations and your view are built?
Suggesting this in case you haven't tried but you can use built in Table Calculations that help you explore your data even more, see Table Calculation Types for more info. A screenshot/example below, I used a Percent of Total table calculation that show me the percentage of sales per sub-catgory only for items that were ordered in 2017. By default, the view is a crosstab and the % is added to my tooltip (and I can edit it if needed):
Hope this helps a little bit. Have a great day!
Thank you for the response -- I am unable to perform a table calculation on my measure value because my % measure values are calculated differently using a formula. Applying a table calculation on my measure values will not yield the correct results. However, I did find a workaround. If you create multiple dummy measure calculations and place it on the row shelf, this will create multiple marks card and you can place your desired values on the text, details, and tooltips.