How to mark selected values in table?

[ingoniclas]

Hi,

I have a client who wants to see which values have been selected in the same table where the results are shown. Example: I have selected 'Company A' in the field 'Company' and 'Product B' in the field 'Product'. Now these two values should be marked or labeled e.g. by colouring the fields yellow. How can this be achieved? 

Thanks,

Ingo

[tresesco]

In the presentation tab of the chart properties, check 'Selection Indicators' like below:

The green dot beside Period field - means value(s) from the same field is selected.

[ingoniclas]

Thanks. But this is not what I'm looking for. The client wants to send the table to excel and see in this excel table the selected values.

[tresesco · Accepted solution]

You can use getcurrentselections() or getfieldselections() (or even the current selections object itself) to capture the selection information and put it in some object separately or in the same chart itself and then let the user export it. For better formatted user friendly solution, you might have to look for macro which is not a good proposal to consider.

[ingoniclas]

Thanks Babyface! getcurrentselections() will do the job!