Skip to main content
bdeshmukh1-Visitor
1-Visitor
Jan 31, 2019 2:27 PM UTC
Question

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

CarlesColl1-Visitor
1-Visitor
Jan 31, 2019 2:49 PM UTC

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.

Translate
bdeshmukh1-VisitorAuthor
1-Visitor
Feb 6, 2019 2:01 PM UTC

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

Translate
Terms & ConditionsAccessibility statement