Calculate Mix including Subtotals

Maik Burghardt · 2025-07-01T12:14:01+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Dataview

Board 14

Accepted answers

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

2025-07-01 16_36_03-1 Dataview - Library & Guidelines - Capsules _ Board.png

All comments

Mads Meissner

Hey Maik,

Hope this helps.

Best, Mads

Maik Burghardt

Thanks Mads. That works. In the meantime I ended up creating another cube without the detail dimension.