Forum Discussion
bdehning
Post Prodigy
2 years agoRemove Blanks in matrix table
I have this Matrix Table. Here is my Values Measure Top3CauseCount = VAR CurrentRank = [RankCauseGrouping] VAR CountValue = [Count of Total Gross Incurred +0] RETURN IF( ...
MattAllington
Community Champion
2 years agoThe first table you posted correctly displays the results. If you don't want to see the blanks, then set it up like the second table you posted. If you want to use the first table structure with no blanks, please produce the table manually (using Excel) to show what you expect to see. I suspect doing this will help you realise that they way it is in the OP is the correct result.