I have a report where I am showing total orders on a monthly basis along with categories. When I sort the report and select the top 10 categories, some random top categories are being selected. How I can get rid of this?
This is because of the effect of the other dimensions.
Just use the fixed LOD if you don’t want any other dimension to make an impact like below-
{FIXED [Customer Name] : MIN([Order Date])}