Forum Discussion
Doubt in Matrix
Hello Team, I have a scenario where i need to show only the categories which has values otherwise the category should not be shown also the category should automatically appear if we get any valu...
Thanks for the swift response amitchandak ,
But if we use the measure which you have shared we are getting the entire sum / count which is been spread across the date range. for instance if we have values 10,20 & 30 for Jan, Feb & Mar respectively and if we use the created measure in the matrix it is giving us 60 (sum of those values) across the entire date range ( from Jan to Dec) everywhere its 60.