Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

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 ...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

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.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    3 years ago

    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

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      3 years ago

      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.