Hello,
I have a situation which requires a dynamic solution in case input data structure is changed.
Briefly, this is the input file with products in different stores and each store being located in a city (same product can be in multiple stores, but of course same store cannot be in multiple cities).
What I need is to use a Cross Tab tool to have the stores as columns and make the sum of the price per product. But I need this for each single city separately - in this case, I only have 2 cities (C1 and C2) and I could use a filter before the Cross Tab and this way to split the data per city. However, I need a dynamic solution which implies that if the input file changes and I will have 5 or 50 cities to also have 5 or 50 output files (multiple excel sheets or multiple sheets in same excel file, doesn't matter).
I am not sure if and how I could obtain that in Alteryx. If you have any solution, you would really save me 
This is how the output should look like:
What is really important is not to have stores which would not be a part of the city and with 0/null value - this would happen if I just used a Cross Tab with no other filter, but I do not want to see stores which are not relevant and of course with no data.
Attached also the Excel file with the input and output expected.
Thank you!
