Forum Discussion
Custom Sheet View is not working in Office 365
Hi, Just looking for a bit of help. I might know the answer but I just need someone to confirm the reason why Sheet View is not working. My excel file is shared with nearly 40 people in my orga...
So why not have all countries toegther in one table? If you sort the table with the country column as the first sort key you should be OK?
JKPieterse I have it so that each country has statistics next to it as the file is being updated. I don't think I can do that if I have only one table? I want each country seperated into groups, each table with a total row that counts up averages and totals and most common topic etc. it's a bit complicated but I don't see any other way than have a table for each country.
- Hmm. There is always a trade-off between trying to have everything on one sheet (which complicates analysis further down the line) and separating data from logic (which does mean separation, so you can't easily view statistics on your data at the same time as viewing your data). I prefer the latter as you can have a stats worksheet with just a pivot table showing the stats of a country (or multiple countries).