2 of 2 people found this helpful
Please see the attached, I removed the table calc in your market share field and then I added this field to label on the marks card and it seems to work fine now.
The table calc which had been applied takes the view into account, so when items gets filtered out it will update accordingly. Now I've just left it as a calculation rather than a table calc and it should be okay.
1 of 1 people found this helpful
So your formula seems to work fine for me
Although due to you also having Facility in your VizLoD, when I remove all but the first 3 Systems, we still have the lines at the bottom of the chart (which are other facilities with each of those 3 systems). One thing is that the LoD (your formula) no longer needs to be made into a further table calculation (the quick table calc for %age of total) as the market share is now "baked" into the calculation.
Let me know if that doesn't make sense, or if its not working for you.