Hello Tableau Community,
I am a relatively new user of Tableau 10.4 and am having some trouble filtering on Sub Totals instead of row totals. I've tried fixed functions and table calculations and cannot seem to figure it out.
My company has two types of sales (Products & Services). I created 3 columns based on different product ID combinations
I am looking to filter (or create a parameter) based on the cells in Yellow below. When I use a Total Bookings filter, the filter is applied to the row totals instead of the subtotals. A customer can have a positive deal value or a negative deal value. The Customer SubTotal can be negative, but the filter still shows the deals that are positive.
*The bookings below do not represent the customers total bookings. Some customers can have hundreds of orders. The columns will also be expanded to include sales agent name and Product ID. Could also add more columns in the future.
I could really use your help Tableau Community. This one has me stumped!