Hey guys:
I'm just wondering if there is anyway to do level of detail calculation in Alteryx? I used to do a report in Tableau but I'm trying to recreate everything using Alteryx.
I did a sample data set:
So I have a bunch of locations that sells different product. I want a summarize table that preferably one row for each location. I want a distinct count for the "Product Type" for each location on a rolling 12 month basis. I can technically filter out the previous month data, but I'm also trying to automate the as much as possible so I won't need to manually filter every time.
I tried to use summarize tool and do a bunch of group by but didn't work out well....any thoughts on this?
I truly appreciate the help!!!
Input Data:
| Location | Year Month | Product Type | Sales |
A | 201701 | #1 | 0.5 |
| A | 201705 | #2 | 50 |
| A | 201706 | #2 | 50 |
| B | 201604 | #2 | 50 |
| B | 201605 | #1 | 0.5 |
| C | 201709 | #3 | 10 |
| C | 201712 | #4 | 15 |
| C | 201710 | #3 | 10 |
Desired format:
| Location | Rolling 12 Distinct Product Count |
| A | 1 |
| B | 2 |
| C | 2 |
