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

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.

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.

This is my first post, let me know if you need more info.

Expected output for territory 101:

(edit: output to single line)

Territory Comparison ex..yxmd

Common Use Cases

Best Practices

Dynamic Processing

Accepted answers

Yoshiro_Fujimori

Hi,

One way of doing this.

I prefer the below format (see the 1st line).

But I also tried to follow your format (see the 2nd line).

Does it work for you?

Territory Comparison ex..yxmd

All comments

binu_acs

@rlupe Can you explain the logic for calculating the amount of each field? How did you get 911626 as TY sales for 101?

rlupe

Forgot MTY column

Store: 1

MTY: 290

TY Sales: sum MTY 290-301 Sales (Store 1) = $911,626

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)

Same range for Transactions.

Yoshiro_Fujimori

Hi,

One way of doing this.

I prefer the below format (see the 1st line).

But I also tried to follow your format (see the 2nd line).

Does it work for you?

Territory Comparison ex..yxmd

rlupe

Yes this works, thanks!

Will I be able to connect it to the text input below for stores 1, 4, and 7 for their respective MTYs?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703