![External User - Drew Glover (Customer)](https://community.tableau.com/img/userprofile/default_profile_45_v2.png)
Drew Glover (Member) asked a question.
I have a dashboard showing spend broken down by Category, Item, and Date. I want to compare the total spend for all items under each category for the current month against the total spend for those same items in the previous month.
The catch is that some items might have been under a different category last month. I still want to include their spend in the comparison, even if they switched categories.
Essentially, I need to:
- Sum the spend for all items currently under a category for this month.
- Compare that total to the spend of those same items from last month, regardless of their category last month.
How can I achieve this? Any help with calculations or approach would be appreciated.