I'm not 100% sure of your requirements, I don't understand what you mean by the sum to text information. Do you mean you need the total of Blue, Orange and Red ?
My initial thoughts are have you tried putting this on to a dashboard, and then configuring another sheet to tell you the total information that you are looking for ?
Thank you for your reply.
Yes. I need sum of the Blue oraange and Red. Basically row total, ignore the color dimension
Ideally, I would like use the total as filter. So, I will rather keep that information as worksheet rather in dashboard.
Thank you very much your help. I did not know I can use size function to realize that. That is what I need.