I need a little help with the pivot table. I’m trying to add a new column whose value will be the result of the division of two of the other column’s values (i.e. a percentage). Obviously, the percentage function should accept (at minimum) two parameters being the numerator column and the denominator column identifiers for input into the calc. What is the best way to plug in such a function using the webix framework? At first, I was thinking adding a custom operator, but how do I provide numerator and denominator column values into the operator args at that point of the loading (i.e. structure and items aren’t yet available to me at that point I don’t think). Another approach I thought of would be to add a new _percentage() function similar to how _minmax_in_row() or even _calculate_item() but those are always called by _process_rows(). I don’t think I want to go barking that far up the call stack. Anyone know how I might best accomplish this during the loading of values or post-loading/pre-rendering of the pivot data?
ps: of course, I meant ‘custom operation’ rather than ‘custom operator’ above. Has anyone successfully added a column who’s values are the result of an arithmetic operation on two other column values in the same table row?
Do you want to use pivot with predefined configuration or with “config” popup.
While it is not possible to have the above functionality, it is relative easy to update pivot and to allow such kind of functionality for predefined config.
If you have a support subscription -please open a support ticket.
Thanks for the reply maksim! Although having this functionality available within the popup would be awesome, I was more thinking of a predefined config. I do no have a support subscription, as this is my first exposure to webix.
We will include the above function in the next version of Pivot. Most probably it will be available till the end of June
Thats excellent maksim! I’ll be looking for it in the next release for sure!
Hi maksim. Just checkin in to see if this feature made it into an end of June release?