Adding Totals Row

[jenner85]

I would like to add a Grand total row for each column:

It should end up looking like this:

I think having the grand total under the dates is what is throwing me off figuring this out. 

thanks!

Jen

[martinding · Accepted solution]

Hi @jenner85 

Please see below for a possible approach

[BS_THE_ANALYST · Accepted solution]

@jenner85 here's one way, I will submit a more dynamic way shortly:

[BS_THE_ANALYST · Accepted solution]

@martinding perhaps more long winded than the other way (but this is more dynamic as it will work as the number of columns grow); we are leveraging the cross-tab to use the total row functionality. I had to add the extra steps at the end because I wanted to maintain your row order after the crosstab/transposing:

[BS_THE_ANALYST]

@martinding it's situationally more dynamic. I withdraw my previous statement 😂

[martinding]

@BS_THE_ANALYST Yes, haha, it is definitely a more dynamic approach!

[jenner85]

Is it possible to do a subtotal based on the product type using the workflow you sent? I can only seem to get it to put out a total for everything...