Forum Discussion

oakfootballclub's avatar
oakfootballclub
Icon for Helper IV rankHelper IV
2 years ago
Solved

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 ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
    oakfootballclub
    Icon for Helper IV rankHelper IV
    2 years ago

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