Sub and Grand Total

Hi All,

Please refer to the attached flow where the subtotals and grandtotals are calculated for every 'Dept'.

Now I need to enhance the flow to accomodate filtering based on the column 'Sub-Dept'.

Eventually all columns in the dataset should be filterable and grandtotal should always be shown based on the selection. The subtotals work as expected.

Do let me know on any questions.

Actually grand totals are in the Null 'Sub-Dept'

Thanks

SubTotals&Grand.yxmd

Datasets

Developer

Database Connection

Accepted answers

All comments

joshuaburkhow

Hey @JDong

There is already a tool that does sub totals and grand totals. It's part of the CrEW Macros

JDong

Hi @joshuaburkhow

This is excellent...but in actual data I am working on the fields are strings 🙂

Anyway I get over this ? The reason they are strings are since the amount fields I appended with $.

Thanks

Quick Links

Unanswered
Community Events
Groups

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280