Answer1. Create calculation field [Order] using RANK to define how you want to sort [Category]ex: sort by Data source orderRANK(ATTR([Category]),'asc')2. Drag [Category] from [Columns] to [Detail]3. Drag [Order] to [Columns]4. Right click on [Order] -> [Compute Using] -> [Category]5. Create calculation field [Label]AVG(-1)6. Drag [Label] to [Rows]7. Remove all fields in [Label] Marks card8. Drag [Category] to [Label] in [Label] Marks card9. Change mark type to [Text] in [Label] Marks card10. Right click on [Label] in [Rows] -> [Dual Axis] 11. Right click on [Label] axis -> [Synchronize Axis] 12. Right click on [Label] axis -> [Show header] to hide header13. Remove [Measure Names] from Marks card14. Adjust [Size] of [Sales]15. Right click on [Order] axis -> [Show header] to hide header16. Drag [Trend Line] from [Analytics] to SUM([Sales])
Did this article resolve the issue? Thank you for providing your feedback on the effectiveness of the article. Click here to return to our Support page. Open new Case Open a new case Continue Searching Click here to go to our Support page. Knowledge Base Get detailed answers and how-to step-by-step instructions for your issues and technical questions. Community Find and share solutions with our active community through forums, user groups and ideas. Product Help Browse a complete list of product manuals and guides. Available online, offline and PDF formats. Training and Tutorials Learn how to master Tableau’s products with our on-demand, live or class room training.