Here is an example of my data I need sum of Steps for each quarter, the number of columns increases every month. Requesting a solution more dynamic | ||||||
ID | Clicks (April 2017) | steps (May 2017) | Steps(June 2017) | Steps (July 2017) | Steps(August 2017) | Steps(Sept 2017) |
abc | 0 | 4 | 1 | 0 | 4 | 1 |
xyz | 3 | 0 | 2 | 3 | 0 | 2 |
pqr | 4 | 6 | 0 | 4 | 6 | 0 |
man | 0 | 0 | 3 | 0 | 0 | 3 |
nam | 0 | 0 | 2 | 0 | 0 | 2 |
Solved! Go to Solution.
Hi @Manjari ,
I think transposing your data initially will allow you to process it a lot more dynamically. See attached for an example!
Best,
mmenth