Forum Discussion

shep123's avatar
shep123
Icon for Helper I rankHelper I
9 years ago
Solved

Filter by Total Column Sum per Campaign

I am having trouble by the total number of Impressions per campaign. Below is some sample data.   Campaign Clicks Impressions Sessions a 0 0 1 b 0 0 10 c 0 0 5 a 14 16,...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi shep123,

     

    According to your desription, you want to filter the sum of Impressions for each Campaign which is greater than 12000 in matrix level, right?

     

    If so, you can add visual level filters as below:

     

    If I have something misunderstood, please share more information about your expected result and how to added filter.

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi shep123,

 

According to your desription, you want to filter the sum of Impressions for each Campaign which is greater than 12000 in matrix level, right?

 

If so, you can add visual level filters as below:

 

If I have something misunderstood, please share more information about your expected result and how to added filter.

 

Best regards,
Yuliana Gu

  • shep123's avatar
    shep123
    Icon for Helper I rankHelper I
    9 years ago

    v-yulgu-msft you are correct. I thought I did that previously which is why I asked the question. I must have had another filter somewhere else that was causing the issue. Works now though.