Forum Discussion
Analyze Data - Help with Structuring Data to Improve Analysis
MarGines My data is structured in a regular table in another worksheet (see screenshot). This is not a pivot table. I guess what I was looking for was suggestions or specific syntax that would help me get the answers I needed from such a large data set. My brain thinks in natural language, not Excel, so I think that asking a table like this one "Show me the top istat for each location for each year" should work, but it doesn't. Is there somewhere I might learn more about the proper syntax structure and how I might get more out of this tool?
Microsoftskeskali We currently don't have documentation of the sort you describe. Based on the structure of the data, we aren't able to understand "for each year". I think that asking: "top istat based on year 2017 for each location" would give you what you want, but you'd need to ask the same question for each year.
We'll explore how to improve this scenario.
Best,
Mar