Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to Not Summarize Certain Values

I'm trying to write a streaming analytics report for our job operations in the plant. I have just about everything done except some of the jobs are summarizing together instead of being separate. Anytime I right-click the column value, there's not a "Do Not Summarize" option. This report is running DirectQuery, so I turned that off and then tried to look for this option in the values, yet it still didn't give the option. How do I get these values not to summarize? That is, why are there cases where values can have the "Do Not Summarize" option and some do not?

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Are you using a table or Matrix. Try to use table and check for the option.

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , Are you using a table or Matrix. Try to use table and check for the option.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I can't believe I didn't think of that. Thank you so much. Switching from a matrix to a regular table gave me the option. I forgot we put it in this format for a heirarchial structure.