I have created a top 20 in/out set for our products but would like it to work so it shows top 20 products in 2018 but also shows how those product performed last year too.
I would also like to have a total for the rest of the products to show grand total performance year on year.
Do I need a formula to do this?
I've applied filters to context and that seems to work for using multiple filters the main issue is top 20 in 2018.
Thanks for any help
I tried to build scenario you explained using My Superstore. Created a set of top 5 Sub Categories for year 2014. Let me know if this approach works for you.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...