User Profile
Hikmet_JCI
Helper I
Joined 5 years ago
User Widgets
Contributions
Re: Need help matrix table
Hi. Thanks. How do I get it to display correctly when filtering in YP? As in the image: Filter 1-3 Leads are 6 in three periods, 3 periods / 6 = 2, so only L should appear in Column and not multiple times... Have Column new Column = IF( 'Table'[Lead] <= 0 && 'Table'[Quota (%)] < 0.80, "SS", IF( 'Table'[Lead] <= 0, "S", IF( 'Table'[Lead] <= 4, "L", IF( 'Table'[Lead] = 4, "S", "H" ) ) )) I need it for a table and matrix !!Need help matrix table
Hello everyone Need help? I have a table with these columns: Name, FY, YP, Target, Actual, Lead and two calculated columns: Quota (%), (Actual/Target) I need a new column: WENN Lead <=0, "S" WENN Lead >0, "H" But if Lead <=0 and Quota is 0, then "SS" And I need this in a matrix that contains the S, H, and SS my table counts and displays Matrix This way, I can see how many people were in each YP S, H, or SS. And if I filter YP 1, 2, or 3, it should be added. Thanks
