How to get a Dimension Name for pivot table

YOSHIDA_T — Fri, 20 Feb 2026 01:09:48 GMT

As shown in the image below,

I want to get a dimension name for pivot table.

Is there a function that can achieve this?

こんにちは

ピボットテーブルにおいて下記画像のように、軸名を取得するメジャーを作成したいです。

これを実現する関数はありますか？

Re: How to get a Dimension Name for pivot table

marcus_sommer — Fri, 20 Feb 2026 13:40:37 GMT

You may try:

getobjectfield(dimensionality())

or maybe a conditional approach, like:

if(dimensionality() = 0, 'x', if(dimensionality() = 1, 'y', 'z'))