Percentage calculation didn't work because of divisor ( wrong aggregation level)

Hi All,

unfortunately I didn't get a calculation to work in Tableau :-(

May data looks like that

I created a calculation in Tableau saying ([Value 1]-[Value 2])/[Value 1] for both categories.

Output works for Category 1 = B as I have only one value.

I also tried to use  (sum([Value 1])-sum([Value 2]))/sum([Value 1] ) => but for Tableau calculation isn't valid.

I am thankful for any kind of hints.

If you have questions, please let me know.

Best regards

Sabine