Calculate Mix including Subtotals

Maik Burghardt

Hi there,

how can I calculate percentage mix including subtotals?

At the moment it is calculated by group.

The algorythm formula GT doesn't work since I have Years in the columns and it does the math for the sum of all years.

However I need it by year.

Thanks maik

Mads Meissner

Hey Maik,

you may need to work with an additional block where you use the Total By function. If I got you right, you want to have the whole column to sum up to 100% overall, so this would be Total by Year. As the subtotals would still sum up, you have to change them to any other function (I changed block b to Summary = "Maximum value"), so the column total (in this case 808.092) will be displayed in every row.

Hope this helps.

Best, Mads