Hi I wanted to calculate in pivot table by each measure - value1 of each measure/sum(value 2) for all measures. Simply put, I want to replicate what I have achieved in Excel below in Quicksight.

Thanks in advance

Hi I wanted to calculate in pivot table by each measure - value1 of each measure/sum(value 2) for all measures. Simply put, I want to replicate what I have achieved in Excel below in Quicksight.

Thanks in advance

Hi Tanisha,

You can use sumOver - Amazon QuickSight function to calculate the total value of scanned unit and then use that in another calculated field to calculate the results. Based on your example dataset above, use two steps calculated fields as defined below to produce the expected results

- create a calculated field total_scanned_unit as sumOver(sum({scanned_units}))
- create another calculated field Result as (sum(misses)/{Total_scanned_units})*10000

Thank you

Deepak

Hi Deepak!

I seem to have missed this. Thanks a ton I’ll try this. Super helpful if this works!

Thanks

Tanisha

1 Like