Suri
Suri

Reputation: 229

Tableau using excel as a data source

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

Answers (1)

Andy TAR Sols
Andy TAR Sols

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

Related Questions