cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

show row headers and calculate total, as in excel

bdeshmukh
8-Gravel

show row headers and calculate total, as in excel

Hi,

 

I am trying to create a output table, which has column headers as well as row headers, both of which can be drilled down as a tree.
and at the bottom of table, and towards the right end calculate total of columns and rows respectively.

Attached is a reference image.

Can this be displayed with the grid widget.

 

Thanks in advance.

Bhushan

2 REPLIES 2

It won't be exactly what you want, but you clearly can output an infotable with the given format directly (last Row with totals and las Column with Totals). If you want to have Colors you can use Grid Conditional Formatting for it.

Hi Carles,

 

Thanks for the input.

 

Yes, the total column/row at the end is possible.
The Final output data here is grid/table. But the the column headers that I have are in a hierarchical format.
Similar to the column headers, I want Row Headers and they to are in hierarchical format.

 

And the % of a KPI is displayed in the grid, with respect to those column headers and row headers.

Thanks,

Bhushan

Top Tags