Preset Feature Feedback
What is the problem or goal the end user is trying to solve or accomplish?
In Excel or Google Sheets, users can perform calculations based on the table column. For example, column (A+B)/C. This function is very helpful when creating a Total or Subtotal of the column with percentage calculation.
In the case when a percentage calculation is performed in the column, the total will sum all the values instead of performing the percentage calculation of the columns.
Current function:
A |
B |
C Diff (A-B) |
Percentage Diff ((100*C)/A) |
|
|---|---|---|---|---|
4 |
2 |
2 |
50% |
|
4 |
1 |
3 |
75% |
|
Subtotal |
8 |
3 |
5 |
125% |
Expected function:
A |
B |
C Diff (A-B) |
Percentage Diff ((100*C)/A) |
|
|---|---|---|---|---|
4 |
2 |
2 |
50% |
|
4 |
1 |
3 |
75% |
|
Subtotal |
8 |
3 |
5 |
62.5% |
How are they solving it currently?
Currently not possible
What is the recommended solution by the Customer?
Create a function to perform a calculation of the subtotal value, or create a function to perform a calculation based on the generated Pivot table column, not the dimension column (function to define the calculation of ((100*C)/A, instead of ((100*"$table_name.columnC")/"$table_name.columnA").
