Forum Discussion

lavanyak's avatar
lavanyak
Icon for Advocate I rankAdvocate I
8 years ago

table.group

Hello, I am facing issues with Power query Table.Group. I am trying to get the sum of sales for each sector.In total I have 1700 sectors (OnD)), but I am getting results only for 358 sectors.I am n...
Need Help
Gazzer's avatar
Gazzer
Icon for Resolver II rankResolver II
8 years ago

Can you clarify - do you have 1,700 unique sectors? Or does your table have 1,700 rows of data, with 358 unique values?

 

Sorry if this seems like a patronising question, I just can't think of another way to explain it, based on such a small sample of data.