Thank you Shin! However, I need a LY & TY customer count for the spend buckets so how many customers fall into the less than 100 bucket last year and how many are there this year.
The dates in the file are not really relevant or useful here.
Please let me know if I can still use pivot for this.
Thank you again,
I think pivot is still effective solution, but I don't understand your comment very well.
If you have specific logic, put the formula or let me know if formula to reach the logic is unclear.
Also if you have specific dimensions to put as color, put it instead of "date".
Also you can create new dimensions with appropriate logic, again let me know if the formula is not clear.
I don't know which logic you want to apply.
Do you know if the Pivot functionality exist in Tableau 10? I can’t seem to find it as described.
That's depend on the data source you are connecting.
Edit data source ==> follow illustrations.
You can pivot the data in your Microsoft Excel, text file, and Google Sheets data sources from crosstab format into columnar format to more easily perform analysis.
Or, if you are not working with the types of data listed, you can use custom SQL as an alternative way to pivot your data in Tableau.