I have a chart that displays a list of my top customers. This is adjusted by a slider that has a variable vTopN. It all works fine except the actual total is a sum of all customers and not what I set my slider to i.e. I set the slider to 5 - it shows me only 5 customers and there sales but the total is still the total of all customers. I have searched the site for a answer but do not know enough about codeing to work it out myself. I have tried certain sugestions i have seen in the forums like set the expression total to Sum of rows, but my total still remained of all customers.
My current expression is:
sum({$<Transaction={'Bills'}, Ledger={'Actuals'}, Year={$(=Max(Year))}, Quarter=, Month=, Week=, Day=, Date=>}[Billed Net Value])
Hi, sorry this is the first time I am uploading something. I think it should be ok. I had hidden script with section access. I have removed this. I hope it open ok now.
There is still one issue. The code Eduardo gave me above does indeed limit the results to what the slider is set at i.e. 5 customers, but it seems to take the first 5 customers in the table instead of taking the Top five customers. So I have this list where the sales manager wants to see his top performing customers, by default I set the slider to 5 but it needs to be adjustable, does anyone know the final piece here so I can get the result required?
