Hello All,
In the attached file, I need to get percentage of TAT met for that week.
I used a pivot table in which the first dimension is Year, second dimension is Week.
and in expression I used like TAT Met % as count({$<TATMet={'Met'}>}TeamName)/Count( Distinct TeamName).
This gives the correct % only if both year and week is selected, if it is not selected, then for year it is giving the cumulative %.
Can any one help me in getting the exact result.
For Eg. I need some thing given below
For 2013 Week 1, number of process for TAT Met is 5 and the total number of process of that week is 6, then TAT Met % is (5/6)*100
And for 2013 , number of process for TAT met( addition of all weeks) is 100 and total number of process for that year is 150, then TAT met is (100/150)*100 , but currently it is just taking the sum of weekly TATMet%, which is wrong