How to Not Summarize Certain Values

[Anonymous]

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?

[amitchandak · Accepted solution]

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

[Anonymous]

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.