any help is much appreciated?
1 of 1 people found this helpful
So you won't be able to do this with Data Blending. The way a Blend in Tableau works is that it's an aggregate and Join. So for your Blend field (Category) the secondary source is aggregated to this level, and then "joined" back onto the primary. So you are unable to increase the grain of the primary from the secondary.
Now we have cross data-source joins, why don't you join the 2 data sources? or (although you have dismissed this) blend them the other way?
So in this case there is no possibility to create primary group for sub category?
Not blending that way round. The primary datasource is only at Category
level (this is its grain or granularity), so say for Category X, it has
sales of £100. It has no way of knowing how this £100 should be split up by
SubCategory...which is why using a blend you can’t increase its
granularity. If you join, or blend the other way it will increase the
granularity. Now the problem with this way is that when you join, say, with
3, say, Sub Categories it will repeat the £100 3 times, so the total will
be £300. You could handle this via LoDs, or if you blend the other way (so
the Sub Cat datasource is the primary) the blend will handle the aggregate
& join and you’ll only get £100.
On Wed, 1 Aug 2018 at 16:21, Karthikeyan Masialamani <