Bar Chart to represent Products by Branch, by month and Year

[jmd25]

Hi all

I am struggling to get the output from the reporting tool that is in my head. I have data from various shop branches. There is basically a binary value for sales on products, VAT applied, VAT not applied. I am looking to present per product, the total sales with and without VAT, by month, by year. 

Year	Month_Number	Branch_Number	Product	Month_Year	VAT_Applied	VAT_Applied_Count
2016	2	2	Apples	2016-02	Yes	2000
2016	2	2	Apples	2016-02	No	50
2016	2	2	Oranges	2016-02	Yes	1500
2016	2	2	Apples	2016-02	No	20
2016	2	3	Apples	2016-02	Yes	1400
2016	2	3	Apples	2016-02	No	100

Ive attached what I am looking to do below (excuse the crude drawing). 

I may also need to represent Apples for all branches in a single report. However, not sure if this will work space wise yet.

Thank you in advance.

John

[alexnajm]

I think this is a repost of a thread that has already been replied to? Bar chart to represent product information over ti... - Alteryx Community

[jmd25]

It is. Was having difficulty posting, kept getting errors. Must have actually posted one of the times it errored out on me. Thanks.

[alexnajm]

No worries! I would mark this off so that this thread closes then 😊