Can anyone help!
I have created 2 Column Selections to enable a time comparison based on customers and there customer grouping. I have then created a top n condition to ascertain top 25 customers. To finish off my query i have created a formula to calculate % diff between the two selections. The problem I seem to be having is getting the variance calc. to calculate correctly on the results row. I have marked the selections to calculate results as summation however when I do this for the formulas I do not get the correct results. Am I missing something?