how to add subtotal on additional row

[Beckyli]

how to add subtotal on additional row. sample data on sheet1, i want to show like sheet 2.

[DataNath · Accepted solution]

Hey @Beckyli, how does this look?

[Beckyli]

if i want to "ABC Total" instead of Total, how should i add "store name +Total" on formular

[DataNath]

Hey @Beckyli, you'd just edit this expression to place [Store Name] beforehand:

if IsNull([Store #]) then [Store Name]+' Total' else [Store Name] endif

[Beckyli]

mine is not work.

[DataNath]

@Beckyli have you re-ran the workflow since adding [Store Name] in front? I can't replicate the issue unless I remove [Store Name] like so:

Without

With

[Beckyli]

i re run the workflow, but still not showing the store name before the Total.

[DataNath · Accepted solution]

@Beckyli if you close and re-open the workflow and then try to run it again, does that help? Unless I'm missing something obvious, I really can't see why this wouldn't work - the fact that the expression is all coloured and you haven't received any erroring also suggests it's fine.

[Beckyli]

thanks, i got.

if i need add grand total row which means i summary all total row, how should i do

[DataNath]

@Beckyli I've just added another branch of Summarize + Formula that essentially totals the sub-totals before Unioning them onto the bottom of the final dataset: