Pivot table component

[ninetteadhikari]

Is your feature request related to a problem? Please describe.

Acceptance criteria

GIVEN I have projects in my workspace
AND I click on a Project go to the results framework page
AND I click on the Indicator tracking

WHEN I click on the Indicator tracking from the side navbar

THEN I see options to select the following:

• Row dimension: a drop down field
• Column dimension: a drop down field
• Calculation: Sum/Count/Average etc.
• Calculation column: a drop down field

For the Row dimension, Column dimension, Calculation column the user can choose a column from the dropdown. Properties from the following models are available in the dropdown for the user to choose from:

• Indicator: Allow user to choose one of the properties: name, status, level etc.
• Objective
• Results
• Disaggregation type: List all disaggregation types for user to choose one
• Reporting period

For the Calculation column show fields which are of type number when Calculation type is chosen as 'Sum' or 'Average'

Example 1

• Row dimension: Indicator: name
• Column dimension: Reporting periods
• Calculation: Sum
• Calculation column: Result

Example 2

• Row dimension: Indicator: name
• Column dimension: Reporting periods, Disaggregation type: Sex
• Calculation: Sum
• Calculation column: Result

Packages available:

Pivot table

• npm: https://www.npmjs.com/package/vue-pivottable
• github: https://github.com/Seungwoo321/vue-pivottable
• demo: https://codesandbox.io/s/vue-pivottable-ui-base-3y36u?from-embed
• docs: https://seungwoo321.github.io/vue-pivottable/

Webdatarocks

• npm: https://www.npmjs.com/package/vue-webdatarocks
• github: https://github.com/WebDataRocks/vue-webdatarocks
• demo: https://www.webdatarocks.com/demos/javascript-pivot-grid-demo/
• docs: https://www.webdatarocks.com/doc/api-list/

[ninetteadhikari]

@ninetteadhikari to add detailed acceptance criteria for pivot table component

[amosnjoroge]

@michaelbukachi as a first pass we can scope this ticket based on the following acceptance criteria:

AC

• The spreadsheet should contain two column header.
• First column should be able to merge the first two cell rows
• The second column should contain subheading columns

Basically implement: