I can't figure out what the problem is. Can you do a mock-up of the view you want, and the view you get when you try?

The main problem here is that your data is 'misaligned', i.e. each day has A value on one row and B value on another. If you can re-shape your data so that each day has both A and B values on the same row, then the task becomes very easy. Is it possible?

If not, you will either have to settle for an ugly graph or use table calculations.

Hi Gordon,

I had a go at this (just trying to improve my own skills by checking out forum posts ) and got close to what I think you want

The main key is to add TxnDate (as an Exact Date) into the Level of Details shelf.

This still doesn't give you a correct total value at category level - just the correct grouping by category of the bars. The quickest way I could think of to get the totals as labels was to use reference lines. Also, any category with a total of 0 will still show.

Might not be exactly what you want (especially with formatting of reference line labels being so limited), but it's close without having to re-shape your data and use table calcs.

If you need to make the chart a bit more complex, you might have to go down the re-shaping/table calc route anyway.

Hope this helps,

Tram.

The ugly graph is the result of the same approach as Tram's, but without colour-coding by category. It turns out that adding colour makes it look fine, even though all the segments visible on the ugly version are still there.

Hi Dimitri, for bar charts, Tableau turns on borders as soon as you drag a discrete pill onto the Level of Detail shelf, to show that the bar chart is stacked, so you can always manually turn them off.