4 Replies Latest reply on Aug 15, 2017 7:18 PM by Shinichiro Murakami

Cumulative Column subtotals in Tableau - Help Needed

Hi All,

I was asked to build a report to calculate the cumulative subtotals based on their groupings. Please look at the below table and kindly let me know if this kind of calculation is possible in Tableau.

 Business  Group Function Group Sales Grouping Comments North America Legal Cost 100 G1 Operation Cost 23 G1 Maintenance Cost 23 G1 Total 146 Sum of all G1's Selling Costs 45 G2 Plumbing Costs 12 G2 Total 203 sum of G1's &  G2's Cutter Cost 34 G3 Procurement Cost 56 G3 America Cost 67 G3 Pipeline Costs 87 G3 Total 447 sum of G1's , G2's  & G3's Management Cost 556 G4 Total 1003 Sum of all groups
• 1. Re: Cumulative Column subtotals in Tableau - Help Needed

HI Durga,

Kind of tricky concept, but I got expected result by this.

Thanks,

Shin

<< Ambassador Spotlight Here ! >>

• 2. Re: Cumulative Column subtotals in Tableau - Help Needed

Hi Shin,

Is it possible for you to attach the Tableau Report?

Regards

Durga

• 3. Re: Cumulative Column subtotals in Tableau - Help Needed

Hi Shin,

I just followed exactly what you have described but it's not able to calculate the total by groups wherever the group have single entry. Pasted the screenshot. Can you please have a look.

Green - Totals are correct

RED - Totals are missing

Is this something to change with the formula "IF SUM([Cost Amount])<> MIN([Costs LOD]) THEN RUNNING_SUM(SUM([Costs LOD])) END"

• 4. Re: Cumulative Column subtotals in Tableau - Help Needed

Durga,

Good point.

I still did not give up and I found another approach. (Not always good thing, though)

Try this one, then.

Thanks,

Shin