Subtotals / Nested Subtotals

Hi all,

Please refer to the below report

From this dataset I need to generate all the yellow lines.

Attached in this post is also the dataset using which I need to arrive at above result. Is there a way the nested subtotals are calculated ?

Right now it is fixed to only the levels shown in the image. Also to note is that the Subtotal names are available in the input data sheet that is available.

Thanks

sadata.xlsx

Datasets

Output

Common Use Cases

Accepted answers

AngelosPachis

Hi @JDong ,

You can use the cross-tab tools to estimate the sub-totals, subject to the fact you have created the correct groups, sub-groups earlier on. I have prepared a workflow that I think answers your question.