UX Waterfall Chart Total ignores element weight

[aku]

Hi all, I built a waterfall chart in UX and I found the total bar in two sides are taking the sum of every element regardless of the element weight set in TM1. Would like to know if there is any workaround or configuration I can do?

[Ulas]

This should help. You can create a weight attribute for the dimension and reference it in the advanced options.

  "chartOptions": {
    "inverted": false,
    "chartNullValues": true,
    "absolute": false,
    "waterfall": {
      "weightAttribute": "W",
      "upColor": "yellow",
      "downColor": "pink",
      "singleEndPoint": {
        "color": "#a5a5a5",
        "addTotal": true,
        "totalName": "total"
      }
    }
  }