wrong percentage of subtotal

Question

I'm having an issue with table calculations in tableau. I've got sales per manager and the target. I wanna have a calculation of the target achievement.

Answer 1

This issue can be fixed by modifying your % field  formula to indicate the tableau that you  want to calculate the  subtotal by summing up  all the profit values in the first partition and then calculate the percentage by dividing it as (330000/532000)as:

WINDOW_SUM(FLOAT(SUM([Profit])))/WINDOW_SUM(FLOAT(SUM([Target]))).

Want to be an expert in Tableau? Check out the Tableau Training to get the right assistance.