Hey Community,

To begin with I am new to Quicksight and I have a dataset which I am not able to determine (the correct syntax and hence the calculation). Based on the figure below I am trying to calculate the

- Sum of all the a’s / sum of all the b’s * 100 to get the percentage value.

This is what I am putting in the calculated field: `sum({metric_name}=['a'])/sum({metric_name}=['b']) / 100`

But there is always an error showing up

Problem: I am unable to use the value ‘a’ in the calculated field.

Note: Is it possible to do it or we need to have separate columns for a,b,c, individually?

Can someone please help me out here.