on 06-06-2019 9:47 AM
Dear all,
I hope you are well?
I have a blockage in the addition of the filters for the Custom Analytical Queries tile, in fact I would like to add filters that are the number of invoices per customer and the total of unaffected by customer, to have a more detailed view on the customer aged balance for reporting and analysis.
I would be grateful if you would inform me of the best solution or the best practice that would be the most demanding to unblock the situation.
Best regards.
Karim
Hi Karim,
From the brief description provided I would recommend to add a 'count' measure at the CDS level of your query that will count the # of times an invoice (accounting document) exists for a customer and thereafter at the query level you could add restricted measures or input filters with regards to the number of times an invoice occurs for a customer. I am not sure about what is meant by the 'total of unaffected by customer' and therefore would not be able to comment on that.
Hope this helps,
Thank you,
Feras
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.