Forum Discussion
Incorrect Matrix SubTotal
Hi everyone, I've got a problem with a matrix subtotal in "TC" and also not reflecting it at the total. Any suggestions? Thanks, Sol
Hi anyone knows how to solve a problem where i have a rankx of taking top 20 only and i want to remove the rows that are not in the top 20. im using a matrices chart and it has hierarchy with country>customer>product. i want to remove country, customer and product that are not in the top 20 list. can someone help me with this please?
I have to use a dax to do this and have tried using the filter pane hiding blanks, NOT ISBLANK,BLANK(),but its not working.
Hi,
Share some data and show the expected result.