如何在Plotly中为瀑布图添加合计值列

import plotly.graph_objects as go
import pandas as pd

data = pd.DataFrame({
    'Category': ['Sales', 'Expenses', 'Profit'],
    'Amount': [100, 60, 40]
})

total = data['Amount'].sum()
data = data.append({'Category': 'Total', 'Amount': total}, ignore_index=True)

fig = go.Figure(data=[go.Waterfall(
    name="",
    x=data['Category'],
    y=data['Amount'],
    measure=["relative", "relative", "total"],
    textposition="outside",
)])

fig.update_layout(
    title="Waterfall Chart with Total",
    showlegend=False,
    xaxis=dict(title="Category"),
    yaxis=dict(title="Amount")
)

fig.show()