cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Analytical Queries tile

Karim_OUBRAHAM_
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Feras_Al-Basha
Advisor
Advisor
0 Kudos

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

Answers (0)