Dynamically Update Another sheet in Excel

@Kallis
First this is an open discussion anyone is welcome to suggest his solution.

If they do not have any access to Alteryx, then how they could select the cost centre? Are you looking for a solution in excel or Alteryx?

Why don't you create the sum to all cost centres and then they can keep what they need?

All comments

@Kallis

There are several ways on how to do it, one of them will be to have all the Cost Centre connected to a List Box tool in the User Interface menu, then get the automation sum up the totals for each of the selected cost centers and then write it to the other sheet.

Hi @OTrieger

Let me try this but is there any other way?

Regards

Bobji

@Kallis
Well, as long as you want that it will be based on the user selection, you will need to use User Interface option. You can use any of the user Interface tools for that purpose, it can be a List Box, Drop Down, Text Box you can select any one of them. Each have advantages and disadvantages.

You can create an automation that by default will create all the totals and then the user can delete those that he does not needs.

As long as the requirement is that the user will be able to select the cost centre, you best choice is to go with the User Interface, as that is exactly what is the purpose of it.

I have not used any of these tools but when I saw some videos, it seems that the selection happens within the Alteryx application itself. If that is the case, the end user does not have Alteryx installed on their machine. They only work on the Excel that is generated. Kindly let me know.

Would you mind sending a sample WF with the data above?

@Kallis

Does the users have access to Alteryx Gallery, a server where the automation is saved and run it as analytic app?

Because if not then you last option is to set it based on excel file given from the user for his preference, but in this case it will be better to create totals for each of the cost centres and then the user can delete what he does not need from the excel output file.

The end users do not have access to any version of Alteryx. They are all pure financial people and lack technical knowledge.

I think that they have asked for a requirement that even Excel cannot fulfil. I mean, in Excel, if you SUM a list of values for a specific cost centre and change the cost centre, that cell will not reflect the SUM for the new cost centre.

With your permission, shall I ask for support from the others?