1 of 1 people found this helpful
Tableau works a bit differently than Excel, so some things that seemed easy in Excel may seem difficult in Tableau at first, at least until you start to understand how it works under the covers. After that, I think you'll find that Tableau is very powerful and makes a lot of your data work much easier than Excel. That said, to do this, you'll need to create a calculated field that will give you August only. It would look something like this:
If [Month]=8 THEN
You can then take this field and drag it up to filters. It should change that filter to a SUM and will allow you to select anything greater than 9000.
Note: If you can share your packaged workbook, then we can show exactly how to do it with your data.
Thank you so much for your quick reply. I'm trying really hard to get out of the Excel mindset while learning Tableau, but it's been a challenge. I know it will get easier as I learn more about Tableau.
So, I created a calculated field like the one you suggested and it worked. However, when I add it to the filters and filter it to show all under $9,000, my other month columns disappear. Is there a way to show the sales for the previous months, as well as, the Aug sales when using this filter?
Hope you are enjoying your Tableau journey. The formula you are using won't be able to show other months as-is. However, because you want to see how it's doing comparative to the months next to it, would it be better just to add a color filter to highlight anything under 9,000? Then you can easily identify which people have under 9k across all months, and you can see how they are trending.
something like [Sales}<9000 and adding that to the color section on the marks card.
I know this is a little different than what you asked, but maybe a change of direction will help. Good luck!
Oh yes of course. We'll need to do something a bit more complex. Typing from mobile at the moment. When I get a chance I'll respond with another solution, unless someone else beats me to it.
Megan, any chance you can share a sample of your data, even if it is just a mockup in the same structure? It's pretty difficult to answer this properly without seeing the structure of your data.
Hi, just following up on this one. Let us know if we can be of any further assistance.