This content has been marked as final. Show 4 replies
If you can provide a sample Access database, I'd be happy to help you with this.
Here's what I would suggest:
- Create a query in your Access database, which sums up the data in the table and structures it in a similar fashion to my sankey template.
- Create a table in the Access database which has the static data from the Model tab on the sankey template spreadsheet.
- Replace the Excel data source in Tableau with the Access data source.
Thanks Ken. I will take at a look at this later today and also the email you sent me.
Works perfectly - thank you once again Ken.