Forum Discussion

tkaczmarczyk's avatar
tkaczmarczyk
Regular Visitor
11 years ago
Solved

"Do not summarize" missing

Hi!   Is there a reason why I can't select "Do not summarize" for any of my number fields?      The data I'm using here comes from an Azure SQL database.    Does this feature exist for any...
  • andre's avatar
    andre
    11 years ago

    tkaczmarczyk unfortunately, unlike Power Pivot in Excel, the Desktop does not support "Do not summarize" right now.  The only way to get rid of those Sum symbols is to mark your columns as text instead of number (so you can have your Year column of data type Text and not Whole Number).  

     

    Not elegant by any means but helps in the short run until it gets fixed, hopefully soon...

andre's avatar
andre
Memorable Member
11 years ago

tkaczmarczyk unfortunately, unlike Power Pivot in Excel, the Desktop does not support "Do not summarize" right now.  The only way to get rid of those Sum symbols is to mark your columns as text instead of number (so you can have your Year column of data type Text and not Whole Number).  

 

Not elegant by any means but helps in the short run until it gets fixed, hopefully soon...