Please attach sample data as twbx format and illustrate what kind of action you expect.

Thanks,

Shin

Need to see the data, could you please attach.

Shin

Hi Mark,

You can assign a URL action to a particular Row.

So in the above screen-shot you can assign different urls to a,b,c,and d  row wise. Is this what you are trying to achieve?

Soham

I guess, you will have to create an additional field in the database which will hold the URL,
So if you want to have different URL`s for different departments, then create an additional column URL- which will hold the actual URL for each department.

You can then create your table and include the URL column something like this

and create a hyperlink action

and then lastly just hide the URL field from the actual view(you can keep it if you want to). This will get you here

and you will have different URL`s for different rows

Let me know if this helps.

Soham

Hi Mark,

Action required trigger, which is always "Dimension".

In your case, the cell is consist of "Dimension" and "Measure value(Measure name)", not dimension.

So assigning action to respective cell is not available.

To make that happen,  you need to convert Measure name to dimension with Pivot.

However, that will break all the formula you already created and the book creation need starting over.

You can judge the starting over is worth paying to add this function or not.

If you think it is, you can start from here, and if you have questions, you can post new one.

Pivot Data from Columns to Rows

Or if you really need this function, please reply so, I will assist as much as possible, but please remember all the works you made need to be redone.

Thanks,

Shin

can you upload the latest workbook? one with this issue?