how to avoid aggregation without certain field

[oakfootballclub]

there are 3 dimensions and 1 value filed, if I drag 1 demension and value into a table, and the left two dimensions into silcer, I set  the value as don't summarize, then the value would aggregation automatively,  Ibut I want to see the deails and without value aggregation, how to solve it?

[Anonymous · Accepted solution]

Hi @oakfootballclub 

Thanks for the reply from @Uzi2019 and @Idrissshatila , please allow me to provide another insight:

Open the model view and you can hold down the Ctrl or Shift key to select all the field, and select None in the summarize by drop-down box in the properties pane:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Uzi2019]

Hi @oakfootballclub 

Check the screenshot with Sum (aggregated values) and without Summarization. 

Let me know if you have any other issues. or you can depict the scenario in excel if possible.

I hope this solution works for you!

[oakfootballclub]

Thank you. I actually did set not to aggregation in the value area. Is there any alternative soultion to this problem?

[Idrissshatila]

Hello @oakfootballclub ,

one thing is that you can change it's data type to text.