I have a table showing MAT sales of my Top 3 products on the left. I would like to add another column - total sales - to show the total sales in that period regardless of product (but only for my top 3 products). However, when I added TOTAL to my formula, it disregards my set analysis for Top 3 products and "Product B" appeared, as seen on table on the right. How do I get rid of the highlighted rows?
I've attached a sample app. MAT has to be calculated on the frontend because I would like the period to be flexible + users may make other selections. Any help would be greatly appreciated!!!