Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would need to calculate a subtotal in one line, without having to insert a partial sum from the Properties/Presentation line.
I attached a picture with the columns I need to calculate a subtotal for, after that I would need a Partial sum, that ommits the calculated subtotal.
Please also find attached the QV file too.
Thank you,
Nandor
There is no need to create another column.
You could use something like this:
[Activity type], [Activity types with subtotals]
Dans, Dans
Înot, Înot
Mic dejun, Mic dejun
Prânz, Prânz
Șah, Șah
Dans, Subtotal1
Înot, Subtotal1
Mic dejun, Subtotal1
Prânz, Subtotal1
Șah, Subtotal1
Plată servicii, Plată servicii
Rata lunară, Rata lunară
Plată servicii, Subtotal2
Rata lunară, Subtotal2
Then you could replace [Activity types] with [Activity types with subtotals] in your table.
Hi.
Group your Activity types properly (for example create another field) and you'll have two subtotals.
I though about that but it would have been more elegant not to introduce an another column.
Thanks for the suggestion.
There is no need to create another column.
You could use something like this:
[Activity type], [Activity types with subtotals]
Dans, Dans
Înot, Înot
Mic dejun, Mic dejun
Prânz, Prânz
Șah, Șah
Dans, Subtotal1
Înot, Subtotal1
Mic dejun, Subtotal1
Prânz, Subtotal1
Șah, Subtotal1
Plată servicii, Plată servicii
Rata lunară, Rata lunară
Plată servicii, Subtotal2
Rata lunară, Subtotal2
Then you could replace [Activity types] with [Activity types with subtotals] in your table.
A simple and perfect solution, thank you.
Hi,
Can you atleast show the exact script? I also need this function. I got confused.
Hi,
PFA.
Regards,
jagan.