Sub and Grand Total

[JDong]

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

[echuong1]

The issue is because you don't have any sort of indicator stating that that particular total line is associated with those records. You'd need another column that specified the value MKT, or add the value to the column you're filtering on, and filter on that.

Looking at your workflow and the way you're calculating the totals, it's not very dynamic. It works if you need the total by department, but what if you wanted value by region (US vs CAN)? I suggest doing the filter first, and then calculating the totals.

By Region:

[JDong]

@echuong1 

Thanks ! This helps but in my use case I will be applying the filter on a vizualization tool.

How can I handle this filtering on the reporting layer ? Any thoughts ?

[JDong]

@echuong1 

Seems a dead end ? Any tips please ?

Thanks