To help I think you need to understand what Tableau wants/needs as a data source... I'll try and explain -
Tableau wants raw data (i.e. the pre-pivoted data) you then use Tableau to create - pivots, graphs, maps etc.
I describe to colleagues that I want a wide flat file, I want the fields in columns (and as many as required - the width) and I want the data in rows, at the lowest granularity possible (the flat). I then use Tableau to aggregate/ disaggregate the data as I want.
For an example/ confirmation - check out the samples provided with the product
If I load a finished product (i.e. a pivot table), I can only report the finished product. If I pass the raw data I can do anything. What you want to do is circumvent Adobe Workbench and plug Tableau into the data source .If you can't pass raw data to Tableau I would suggest stopping your research on Tableau as you'd waste your time...
1 of 1 people found this helpful
Additional reading: the first is particularly useful to you
You could use VBA to back fill the empty cells in Excel but I would strongly advise connecting straight to source instead!!
I suspected this might be the case. Unfortunately it is increasingly looking like Tableau isn't the tool for us.
As a Tableau user and ambassador I'm sorry to hear that, but id prefer you knew the tool and its limitations ahead of purchase rather than after. That said, the data 'limitation' isn't Tableau specific - its going to be the same across a lot of BI products.
If you're able I would strongly advise looking at connecting directly to source and/or introducing a data warehouse for reporting. Then Tableau (and competitors) would be much more suitable.
This maybe useful >> Magic Quadrant for Business Intelligence and Analytics Platforms
Best of luck!
It maybe worth talking with someone from Tableau Sales - describing your situation/ requirements they maybe able to offer some alternative/ complimentary advice.