Hi, Requesting help on a dynamic solution on finding the sum of Steps

[Manjari]

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

[MarqueeCrew]

@Manjari,

You might want to explore the CReW macros and use the Add Totals macro to your workflow.

Cheers,

Mark

[mmenth · Accepted 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