Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Hi,
Can you elaborate with an example?
Regards,
Jagan.
thanks
But I want all the fields of original table not fields only present in the pivot table.
Thanks
Pavan
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
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
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.
=$(=concat(chr(39)&$Field&': '&chr(39) & ' & ' & 'concat(distinct [' & $Field & '],' & chr(39) & ';' & chr(39) & ')' , ' & chr(10) & ' ))
Thanks