Thanks for the reply!
Sorry there is a typo in my original post. the Brand_Top_Calculation is: if(len($(vTop_Customers))>0, Brand,null()). vTop_Customers is the variable I am using to get the top 25% customers listed in the above post.
Here is the sample without the Brand_Top_Calculation
Brand Customer Sales Top 25% Customer A C1 800 C1 A C2 700 C2 A C3 600 - A C4 500 - A C5 400 - A C6 300 - A C7 200 - A C8 100
Here is the sample with the Brand_Top_Calculation:
Brand Customer Sales Top 25% Customer Brand_Top_Calculation A C1 800 C1 A A C2 700 C2 - A C3 600 - - A C4 500 - - A C5 400 - - A C6 300 - - A C7 200 - - A C8 100 - -
Basically, I want to show A in Brand_Top_Calculation in the first two row as C1 and C2 are the top 25% customers in this data set, but one of them is correctly populated, but the other gives me the null value.
I think the issue might lie in the calculation of top 25% customers, but still cannot figure out the exact issue.
Thank you so much for the help!