Forum Discussion
Remove the default SUM OF in variable aggregates
Hello! When I add a variable to my report it is given as a name SUM OF X THING and before that did not appear to me, only the added metric X COSA appeared without the SUM OF, and it is very annoying ...
Syndicate_Admin Select the column in the Fields pane. In the Column tools tab of the ribbon, set the Default summarization to Do not summarize.
I do not know how to do it, I can modify in the column tool, but I do not know how to modify it by default, when I add a new data modeling it is removed again
Syndicate_Admin You can try going to File | Options and Settings | Options and under CURRENT FILE | Report settings all the way at the bottom uncheck the checkbox below Default summarizations. Otherwise, it's just something you have to do when you are creating a new data model or are adding data to a data model. It is one of the reasons I created Metadata Mechanic so that you could do this in mass. Check out the MSHGQM link in signature.