Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have an issue with a set analysis table and grouping or aggregation on 2 dimensions with a Slider for selecting Top customers Sales.
Have tried several combinations with no luck,
please see attached example I put together.
thanks
reagrds Peter
Hi
I have uploaded one application please check is correct or not.
Thanks for your efforts, Gysbert has solved it
thank you agian
and sorry if I did not explain it properly, thats my fault!
regards Peter
The dual function creates a 'value' with both a textual and numeric representation. In this case the numeric value is the sum of the Sales for the customer and the textual value is the name of the customer. That way you can sort it numerically and still display it as customer name.
Excellent example. Thank you very much! 🙂
Big thank you Gysbert! Your response to this question pulled me out of a pit of despair and made my report work the way the client wants.