Forum Discussion
how to avoid aggregation without certain field
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?
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.
4 Replies
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.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!
Thank you. I actually did set not to aggregation in the value area. Is there any alternative soultion to this problem?
