How to dislplay all the fields

[#1]

Hi Friends,

I have created a pivot table with some fields and caluculated a measure from a table.

I want all the fields from the original table into a text box, if the user clik on any value of measrue.

Thanks

[Gysbert_Wassenaar]

Try using the getcurrentselections() function. If you click on a value in an expression column in a chart then the dimension values of that row are selected.

[jagan]

Hi,

Can you elaborate with an example?

Regards,

Jagan.

[#4]

thanks

But I want all the fields of original table not fields only present in the pivot table.

Thanks

Pavan

[#5]

Hi Jagan

Lets say I have a table  with fields A B C D amount.

I added only A B  and Amount.

Now I created a text box where I want all the fields A B C D when I clik on Amount.

Thanks

[#6]

Hi Gysbert

My problem is like this

Lets say I have a table  with fields A B C D amount.

I added only A B  and Amount.

Now I created a text box where I want all the fields  A B C D  and there values when I clik on Amount.

The expression  =concat(distinct FieldValue($Field,ValueLoop(1,$(=count($Field)))),';') is static.

Please help.

Thanks

[jagan · Accepted solution]

Hi Pavan,

Use Concat()

='A Values : ' & Concat(DISTINCT A, ',') & chr(10)

'B Values : ' & Concat(DISTINCT  B, ',') & chr(10)

'C Values : ' & Concat(DISTINCT  C, ',') & chr(10)

'D Values : ' & Concat(DISTINCT  D, ',')

Hope this helps you.

Regards,

Jagan.

[Gysbert_Wassenaar]

=$(=concat(chr(39)&$Field&': '&chr(39) & ' & ' & 'concat(distinct [' & $Field & '],' & chr(39) & ';' & chr(39) & ')' , ' & chr(10) & ' ))

[#9]

Thanks