Skip to main content
B
bdeshmukh1-Visitor
1-Visitor
January 31, 2019
Question

show row headers and calculate total, as in excel

  • January 31, 2019
  • 1 reply
  • 1370 views

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

1 reply

C
CarlesColl1-Visitor
1-Visitor
January 31, 2019

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.

B
bdeshmukh1-VisitorAuthor
1-Visitor
February 6, 2019

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

Terms & ConditionsAccessibility statement