chilly_bang
Board Regular
- Joined
- Jun 17, 2016
- Messages
- 57
I have a table, like this:
How can i calculate the percentage difference of clicks between the latest and earliest date with a formula?
Anyhow like this: IF B3=(B3-1) & A3>(A3-1) → iferror(100-(c3*100/(C3-1));0)
I've tried it with pivot - it works, but after data refresh my pivot gets broken.
Rich (BB code):
+------------+--------------+--------+
| Week | Search query | Clicks |
+------------+--------------+--------+
| 2020-11-09 | keyword 1 | 3 |
+------------+--------------+--------+
| 2020-11-16 | keyword 1 | 3 |
+------------+--------------+--------+
| 2020-11-09 | keyword 2 | 7 |
+------------+--------------+--------+
| 2020-11-16 | keyword 2 | 14 |
+------------+--------------+--------+
How can i calculate the percentage difference of clicks between the latest and earliest date with a formula?
Anyhow like this: IF B3=(B3-1) & A3>(A3-1) → iferror(100-(c3*100/(C3-1));0)
I've tried it with pivot - it works, but after data refresh my pivot gets broken.
Last edited by a moderator: