Can we implement a calculation option within the chart an a grand total at the end?

By chance - is there a possibility that you can implement a calculation option within the chart an a grand total at the end? In this specific request:
Equation: Row 2 x Row 3 = Row 4
All results of Row 4 = Grand total
Thank you very much for your help!
Holger

Hi Holger,

I think this widget will help. http://widgets.jotform.com/widget/spreadsheet

Just like normal spreadsheets, you can create formula to calculate the rows and a formula to get the grand total.

Hope this helps. If you need further assistance, let us know.

Regards!

Dear EltonCris!

Thank you for your reply. Somehow I don't get the calculation form to work. Row D should display the result of multiplication of row B and C: Can you help.

Is it possible to change the header row names, e.g. "A" to "Product number"?

 

Thank you so much for your help!

Holger 

There are samples on the widget description which you can try. I have just tried it and it's working fine.

Header letters (e.g. A, B, C) are default and can't be changed just like spreadsheet. However you can add text values on the first row as your headers.

Example with formula D = B*C

A1 First Header
B1 Second Header
C1 Third Header
D1 Grand Total
D2  = B2*C2
D3  = B3*C3

Screenshot:

With regards to the CSS codes, I have move it to a separated thread. We'll assist you with that once we get there.

Thanks!