Great! Thank you – that fixed it!
Updated working code: https://codepen.io/ttwer2/pen/ZEjxBzp
Few questions for pivot:
- Is it possible to add multiple summaries of the same column? for example, sum(expenses) as one statistic and avg(expenses) as another?
- Are we able to define custom stats/calculations for the summary?
- I’m not able to use the conditional formatting mode in the above code – am I missing something? i.e nothing happens when I click the button on the top right corner
- In pivot mode > filters, I’m only able to see the numbers as categorical values where I can select or de-select them. How can this be changed to behave as per the type of column? i.e if number -> then range or if text, then string matching
How can I sort the columns in the pivot? for example, the stdevp(income) and the group in the pic below[Solved]- Is it possible (programmatically) to plot the selection in a pivot via charting capabilities of htmlelements? example:
this would come up in a chart with X-axis showing USA,AUS,UK and y-axis showing stddevp(income)
this would be an excellent feature and I’d be grateful and go for the license if you can help with this! 🙂
Thank you!
