asked on July 26, 2018
For example, https://jsfiddle.net/8ho41k0g/1/.
Say I wish to calculate the "Top Category" as per defined. However, wish to exclude color "green". So green is always 0 for the Top category. Is this possible?
⋅ July 26, 2018
Hello,
Thank you for the question.
Actually, there is no option to write such condition in calculated value formula.
But, you can filter the dataset to exclude the "green" as follows: https://jsfiddle.net/flexmonster/x2t9ac3e/
Also, you can use customizeCell to replace the cell value for "green" row (a bit hacky solution): https://jsfiddle.net/flexmonster/vup89fq5/
Hope it helps.
Regards,
Ian
⋅ July 30, 2018
customizecell looks good. Thanks for the answer.
