Date Table: Pivot Table Support

[srinivass0912]

Issue Type [Mandatory]

• Feature Request

---

Description [Mandatory]

We want a blend component which supports pivot table functionality which we can implement in our tables in analytics

---

---

Expected Behavior [Mandatory]

We should be allowed to build a pivot table from a base table which we currently display

---

[dkrai04]

@srinivass0912 can you describe what all features are required in the piviot table?

[srinivass0912]

The features required in pivot table:

1. The base table from which the pivot table is built, we would need the columns of the base table to be allowed to be added as rows and columns in the pivot table to construct a custom table for our use case
2. The columns of the base table needed to be passed as values. The value computation can be sum, count, average, mean, median etc which is allowed in the pivot table of excel or sheets
3. The sheets and excel pivot table allows filter. We don't require filters for our current use case in analytics, but would be helpful if the filters can be made visible using a prop so that the component is generic
4. There should be a view area when the pivot table is constructed, I can see the rendered table basis the conditions I gave for the pivot table
5. The other table options like exporting the rendered pivot table would be helpful
6. The base table will also be visible and we would want the pivot table to be constructed on top of the base table. The pivot table is not replacing the base table