Adaption of names with drill down

[Anonymous]

Hi all,

I have the following table:

KST1	Name KST1	KST2	Name KST2	Price	Cost
1000	General	1100	Car	3	2
1000	General	1200	Food	5	6
2000	Material	2100	steal	6	4
2000	Energy	2200	oil	7	8

Now I want to show this in a pivot-table with a drill-down for KST1 und KST2 => this is working, but how do I get the names "Name KST1" and "Name KST2" into the pivot-table synchronized to the drill-down for KST1 and KST2?

Thank u for helping!

[pradosh_thakur]

Hi

are you talking about the label name ? you can change it in the edit drill down group

regards

Pradosh

[Anonymous]

HI Pradosh,

thank you for your answer, but I don’t want to change the label name.

I have a drwill-down for KST1=>KST1: how do I get the right name for the status of drill-down => drill-down: KST1 => show name1 ; drilldown: KST2 => show name2?

Thank you very much!

[marcus_sommer]

With getcurrentfield(GroupName) you could query which item is the current one within your dimension-group.

- Marcus

[Anonymous]

Thank you, but I need the result from the group name2:

1000 General

Drillodwn to KST2 =>

1100

Car

[marcus_sommer · Accepted solution]

Try it with this condition within your second dimension:

if(getcurrentfield(GroupName) = 'KST1', [Name KST1], [Name KST2])

- Marcus