How to get first pivot dimension field name

[agigliotti]

Hello,

I'm in trouble with an expression in pivot table because I'd have to know the first dimension field name (ex customer) to change definition accordingly.

That's because I need to allow pivoting.

Of course it would be great if I could conditionally allow pivoting for a single dimension.

Please let me know how I can manage this needed.

Many thanks in advance.

Best Regards

Andrea

[swuehl]

GetObjectField(0)

[trdandamudi]

Can you please share a sample app and explain clearly what you need, so that we can take a look and come up with a solution.

[miguelbraga]

Hi Andrea,

I can't seem to understand your needs without you make a more compreenhsive question. Please describe it giving us a image or explain in a document what you really need. There may be a way we can help you quickly. You can also make in that document a design of your required solution.

Regards,

MB

[agigliotti]

Many thanks to all of you for your quickly support.

[agigliotti]

It's useful but it give me always the first chart dimension regardless the enable conditional settings.

Therefore the GetObjectField(0) function returns the first pivot dimension name even if it's hidden because its conditional expression.