Pivot table row totals not showing

I've got a rather annoying bug with Pivot tables. My Pivot table is as follows:

Activitygroups, with activities. These have locations and within locations rooms. These rooms have the metric i'm showing. This is working just fine as you can see with row totals and column totals working.

The issue only arises when I want to filter by a single location. As I said these locations have multiple rooms. These will still show so it still has values I want to see totalled at the end of the row.

Screenshot:

Sadly this isn't working which is annoying since I have to add by hand to see how much this location's rooms all add up to.

Is this an intended feature? I doubt it.

{
  "browser-info": {
    "language": "en-GB",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:122.0) Gecko/20100101 Firefox/122.0",
    "vendor": ""
  },
  "system-info": {
    "file.encoding": "Cp1252",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "17.0.6+10",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "17.0.6",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "17.0.6+10",
    "os.name": "Windows Server 2019",
    "os.version": "10.0",
    "user.language": "en",
    "user.timezone": "Europe/Berlin"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "sqlserver"
    ],
    "hosting-env": "unknown",
    "application-database": "mysql",
    "application-database-details": {
      "database": {
        "name": "MariaDB",
        "version": "10.11.2-MariaDB"
      },
      "jdbc-driver": {
        "name": "MariaDB Connector/J",
        "version": "2.7.10"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2024-02-22",
      "tag": "v0.48.7",
      "hash": "c192db1"
    },
    "settings": {
      "report-timezone": "Europe/Amsterdam"
    }
  }
}

sorry, so a single location doesn´t have totals?

Yes, that's correct

Same problem here. As soon as I filter anything, the row totals dont show anymore:


Nice to see i'm not the only one.
If you do find a solution please post here.

Hoping for any updates / fixes soon.