Hello,
This analysis concerns a paid search campaign.
I have a Pivot table with numerous rows and 4 column dimensions: Impressions,clicks, Click through rate, cost per click.
All fine except the last one - cost per click. There are numerous instances of the number 0 in this column as some ad groups have had 0 clicks. I want to rank the min, or "best, cost per click ad groups. Obviously I do not want to include zero but rank on the next minimum up.
When I select the filter option on this column I unselect the number 0 yet those rows with zero remain in the table.
How do I filter out occurrences of the number zero int his situation? Any feedback appreciated.
Paul
This analysis concerns a paid search campaign.
I have a Pivot table with numerous rows and 4 column dimensions: Impressions,clicks, Click through rate, cost per click.
All fine except the last one - cost per click. There are numerous instances of the number 0 in this column as some ad groups have had 0 clicks. I want to rank the min, or "best, cost per click ad groups. Obviously I do not want to include zero but rank on the next minimum up.
When I select the filter option on this column I unselect the number 0 yet those rows with zero remain in the table.
How do I filter out occurrences of the number zero int his situation? Any feedback appreciated.
Paul
