Sales and Buy graph on the same temorality

[Anonymous]

Hello,

Someone have already made a Sales and Buy graph like this please : 

I would like someone share its methode because my methode prevents me to add some option like filter on a another category.

[v-zhangti]

Hi, @Anonymous 

You can try the following methods.

Sample data:

Is this the result you expect? If not, can you provide sample data for testing? Sensitive information can be removed in advance.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello, 

This is what I want but how do you make this calcul and can you filter on a category ?

[v-zhangti]

Hi, @Anonymous 

What does your source data look like? What does the category look like?

Please refer to the attachment.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I have a database which contain lot of article with a "in" date, "out" date and a shop it's not concern sales and buy but it's the same idea like this :

Article	Shop	IN week	Out week
A1	A	2023-04	2023-05
A2	A	2023-05
A3	B	2023-05	2023-06

For exampl they two IN and one OUT for fifth week of 2023, and if we specify by shop for the A shop I have one IN and one OUT for the same week. I want to make a visualisation like I show in my previous message except that the method I use makes it difficult to filter this visualization by store.