Hi Jose,

Thank you for posting in our forums.

This is possible if you are using FlatDataSource. It exposes an IinitializeHerarchyDescriptor event which gives you access to the different levels of the hierarchy. This allows you to remove the “All” totals from the pivot grid:

LevelDescriptor level = e.HierarchyDescriptor.

                LevelDescriptors.ToList().FirstOrDefault(lvl => lvl.Name == "all");

if (level != null)

                e.HierarchyDescriptor.LevelDescriptors.Remove(level.Name);

Please let me know if you have any additional questions.