上次修改日期 : 30 Mar 2023
環境
- Tableau Desktop
解決方法
As a possible workaround, create separate sheets to display only the data you want to freeze and the other data, and place them on a dashboard:1. Connect to Sample - Superstore.
2. Change the name of sheet to "Freeze" from "Sheet 1".
3. Drag [Category] to Columns.
4. Drag [City] to Rows.
5. Drag [Sales] to Text.
6. Drag [City] to Filter Pane > Push 'None' > Check "Akron"
//Assume this time that we want to freeze Akron's data.
7.Duplicate sheet "Freeze" and rename it to "Non-Freeze".
8. Right click on "City" in the Filter Pane > Edit Filter > check "Exclude" > OK
9. Right click on "Category" in the Rows > Show Header
10. Right-click on the "City" column of the Crosstab > "Hide Field Labels for Rows"
11. Toolbar > Format > Shading > Set Band Size of Row Banding to the leftmost.
12. Create a new Dashboard.
13. Set the Object to Floating > Drag the sheet "Freeze" to the dashboard.
14. Set the Object to Floating > Drag the sheet "Non-Freeze" under the "Freeze".
15. Set the title of the sheet "Non-Freeze" to be hidden.
16. Adjust the position of the sheet "Non-Freeze" to match the position of the "Freeze".
17. Adjust column widths of sheet "Freeze" to match the width of "Non-Freeze".
原因
This feature is not built in Tableau Desktop yet.其他資訊
To voice your support for the inclusion of this enhancement in a future product release, add your vote to Adding a freeze row, pane, or column functionality.感謝您針對本文的效益提供意見回饋。
開啟新案例
繼續搜尋
知識庫
社群
產品說明
訓練及教學課程
相關連結
Results 1-3 of 526
Trending Articles
Results 1-3 of 526