Reputation: 229
I've a tableau workbook using excel as a data source. The excel uses lots for formulae inside and takes input parameters using cells on a particular worksheet. The issue is I want to input these parameters through Tableau, get the excel refreshed on the backend and show the output of the excel in Tableau. Any suggestions how can I accomplish this? Thanks much in advance
Upvotes: 0
Views: 66
Reputation: 1735
You can create parameters in Tableau. The Excel calculations using these parameters would also need to move into Tableau as Calculated Fields. Basically you would pull the raw Excel data into Tableau and perform calculations there using your Tableau parameters.
Upvotes: 0