Hello. I have attached a simple schedule. I want to sort my schedule first by level (as it is now) and then by name, but I want to merge the areas with same names, because now they are separated (but again level by level). Is there any chance to do this? Something like this:
Level Name Area
Underground 1 Parking places 54561
Underground 1 Toilets 125
Underground 2 Parking places 6454
Underground 2 Toilets 154
Ground floor Offices 54351
Solved! Go to Solution.
Hello. I have attached a simple schedule. I want to sort my schedule first by level (as it is now) and then by name, but I want to merge the areas with same names, because now they are separated (but again level by level). Is there any chance to do this? Something like this:
Level Name Area
Underground 1 Parking places 54561
Underground 1 Toilets 125
Underground 2 Parking places 6454
Underground 2 Toilets 154
Ground floor Offices 54351
Solved! Go to Solution.
Solved by Keith_Wilkinson. Go to Solution.
You need to add in calculate totals against your Area parameter and then in sorting and grouping, sort by level and then name and turn off itemise every instance..
You need to add in calculate totals against your Area parameter and then in sorting and grouping, sort by level and then name and turn off itemise every instance..
Thank you, it works.
Thank you, it works.
Can't find what you're looking for? Ask the community or share your knowledge.