If for the manufacturer A, the % change in value from 2019 to 2020 is 10% for Product A1, 20% for Product A2 and 25% for Product A3. I want 25% to show up besides 'A' and same goes for Manufacturer B. The % change in value of a product which is maximum should show up in the second column besides the column for the Manufacturer.
Can we do this through the Script Editor if not through the chart expressions?
Hi, I think this is double in the front-end by using the aggr() function. It is certainly possible in the script editor. However, I first need to fully understand your exact needs, and unfortunatly, I still do not get it... You provided example data of 2017 and 2018 but your example in the previous comment is from 2019 and 2020. Please provide an example calculation/description including numbers so that I can relate them. After that I can provide and expression or script.