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

show row headers and calculate total, as in excel

Level 7

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

Re: show row headers and calculate total, as in excel

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.

Re: show row headers and calculate total, as in excel

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