How to sum specific month's based on two conditions?

rlupe — Wed, 15 Mar 2023 17:17:45 GMT

Hello,

MTY = Month designation (MTY 300 = Dec 2019)

I am trying to get a store's total sales for 'this year' and 'last year' based on a specific MTY, then want to compare against the stores in the territory for the same time range.

Example store 1:

TY Sales: sum MTY 290-301 Sales (Store 1)

LY Sales: sum MTY 289-278 Sales (Store 1)

Total Territory Sales TY: sum MTY 290-301 Sales for all stores in territory 101 (stores 1, 2, 3)

Total Territory Sales LY: sum MTY 289-278 Sales for all stores in territory 101 (stores 1, 2, 3)

I have individual store sales by month (MTY) and territory in one tool, and the specific MTY and territory I want to compare with in another tool.

Let me know if you need more info.

Expected Output:

Re: How to sum specific month's based on two conditions?

OllieClarke — Wed, 15 Mar 2023 17:56:51 GMT

Hi @rlupe

I think this is what you want:

You join all records per store onto themselves, then you can filter to the range you want.

Hope that helps,

Ollie

Re: How to sum specific month's based on two conditions?

rlupe — Wed, 15 Mar 2023 18:27:53 GMT

This is perfect, thank you!

topic Re: How to sum specific month's based on two conditions? in Alteryx Designer Desktop Discussions

How to sum specific month's based on two conditions?

Re: How to sum specific month's based on two conditions?

Re: How to sum specific month's based on two conditions?