Subtotals / Nested Subtotals

[JDong]

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

[Qiu]

@JDong 

Can you confirm total for 630 is correct?

[JDong]

@Qiu 

Sorry maybe a typo...380 seems right 😁

[AngelosPachis · Accepted solution]

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.

Let me know if that worked for you.

Regards,

Angelos

[JDong]

@AngelosPachis 

Thanks for the response !

This works well and desired solution.