Need support on calculating total

[SCK]

Hi All. Apologies if the question is already populated, however, I could not find a suitable response. I need help in calculating grand total which will pull values only from the rows that contains subtotals. I have attached an input and output file. Please help  me.

[ImadZidan · Accepted solution]

Hello @SCK ,

There is no difference between you input and output.

Is this what you are looking for. I have a feeling its more.

Lets see.

[SCK]

There is a grand total row in my output, which is not in the input file. So, I need a grand total through alteryx which will pull the sum of all subtotals 

[ImadZidan · Accepted solution]

Hello @SCK ,

Apologies, I missed the Grand total record.

Please have a look at the attached.

If this does not tackle your issue, please shout back and we will figure it out.

[SCK]

The version does  not support. My version is 2019.3 x64. Could you send me just the workflow maybe, i.e. .yxmd extension. Maybe that would support

[vizAlter · Accepted solution]

@SCK — Hope the attached workflow will be helpful.

[ImadZidan · Accepted solution]

@SCK ,

of course, I will keep it in mind next time.

[SCK]

Wow! It worked! Thank you so much for your help, really appreciate it.

[SCK]

I have another question, Would you also be able to help calculate subtotals if the number of rows to calculate subtotal is not fixed. I have attached another input and output.

[vizAlter · Accepted solution]

@SCK — You need to create some condition so that we could apply the logics to create Groups for Subtotal, if you get more rows in future? Create a new column as identifier or reference.