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.
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.
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.