dynamic title of a formula

[#1]

hello all,

I just finished designing a pivot table with a drill down grp.

The formulas are changing with the selection of the drill down.

Now I want that the titles are dynamic too.

But unfortunately i didn't work with my actual expression (it is attached als picutre below).

What i 'm doing wrong? Is it generally possible to work with "IF-clauses" in titles?

thanks in advance

daniel

[kamalqlik · Accepted solution]

Hi you can use the GetSelectionField() function for getting the values

[#3]

Thank you.

I just created the right expression, which is working fine.

(see attachment)

[kamalqlik]

You can also use set analysis for better approach....

regards

Kamal