Forum Discussion
Helper IFilter 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,000 | 0 |
| b | 10 | 11,000 | 0 |
| c | 12 | 13,000 | 0 |
When I create by matrix I get the following:
| Campaign | Clicks | Impressions | Sessions |
| a | 14 | 16,000 | 1 |
| b | 10 | 11,000 | 10 |
| c | 12 | 13,000 | 5 |
This is perfect except as constructed but I want to add a filter that removes campaigns with Impressions below 12,000. When I go that I get the following table because it is filtering out the first records because their impressions are less than 12,000.
| Campaign | Clicks | Impressions | Sessions |
| a | 14 | 16,000 | 0 |
| c | 10 | 13,000 | 0 |
Is there a way to build a filter off the total number of impressions unique to each campaign?
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
2 Replies
v-yulgu-msftMicrosoft Employee
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
shep123v-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.