Skip to main content

Hello Experts,

 

following question:

 

I have a table Invoice and a table Bank.  In my Invoice Table are all my Invoices and in my Bank table i can see when my invoices were paid

Now for example i want to know in which months the Invoices of January were paid.

 

Invoice Sum of January 197$.

112$ were paid in January, 55$ in February, 30$ in March

 

Now i got this:

 

Measure in row shelf

 

I try to get the Invoice SUM of a specific month (here 197$ of January) in the view.

I try to put the "money" field in the row shelf, make it discret or tried with an calculated field. nothing works .

 

Help would be appreciated.

 

Thanks

Walter

9 answers
  1. Mar 27, 2020, 7:58 AM

    Hi Peter Neuer,

     

    are you looking something like below?

    Hi Peter Neuer, are you looking something like below?

    You can achieve this by using below calculated field

    SUM({ EXCLUDE [Paid Date] : SUM([Amount]) })

    I am attaching workbook for your reference, let me know if you find any difficulties with this solution.

     

    Thanks,

    Dishant

0/9000