Hi, I am a senior Microstrategy developer but a novice Tableau developer. I just started to learn and develop tableau reports. It is much easier to use and more powerful in Visualition for Tableau versus Microstrategy. However, I have a question about metric filters.
When measure/metric is used as a filter in Tableau, it can be calculated at two different levels: Record level and Summary level. I notice that Summary level is dynamic here and it is actually the gird/graph level.
For example, I have two dimensions: Category and Sub-Category in the grid. I have a measure filter: sum(Sales) > 0 at summary level. This will filter out any data whose sum(Sales) at Sub-Category level is less than or equal to 0. However, if users requires to show sales at both Category and Sub-Category levels but expect the filter to be sum(Sales) at Category level > 0.
How can I do it? Thanks a lot.
I have solved it by myself. I just move forward to read the training video about calculated fields. My question can be easily solved by LOD(level of dimension) calculation based filter. I have tested it and it works.