Forum Discussion
TopN Dynamic Filter in Matrix
Hello Community - I am in need of some help with my TopN slicer and how it interacts with a Matrix. I have a measure that is summing my TopN sales amounts by Item which is working perfect. But...
Hi,
I cannot spot any mistake in the table there. I see the Top 4 items per brand and the total (112,164.73) seems to be the summation of only those 4 items. What is the problem?
Ashish_Mathuryou are correct, the matrix is working perfectly. The issue comes with the trending line graph. That is by brand (items are not a dimension there). But I want the values in the line graph to reflect only the sum of the TopN items associated with the brands. So I would expect all data points for the top brand in the line chart to total the 112,164.73, but they do not.