I have a straight table with the dimensions ModelCode, ItemCode and Measure as Sales Amount, Sales Quantity. I have applied dimension limit on ModelCode to display only those model codes that are contributing to 40% of the Total Sales Amount. This displays around 400 ModelCodes(this is what I want).
Now I add a new column to this table that is Last 4 Weeks Sales. What I expect to see is the last 4 week sales to be displayed only to the model codes that are contributing to the 40% of the Total Sales Amount(i. e. I am expecting that only 400 ModelCodes are displayed with three measures). But once I add a new column the number of model codes are getting increased.
Can anyone help me if I am missing something here?
did you check again the dimension limits tab to see if the order is still the same after adding the Last 4 weeks Sales expression? can you upload a sample document to check?
