Show total with data link

[danielaw]

I would like to have two totals for invoices. One total for invoices with an invoice date within the last 28 days, and one total for all invoices older than 28 days.
Is there a formula that automatically includes today's date?

Thanks

[robert_mika]

Probably:

Sum({
<InvoiceDate = {">=$(=Date(Today()-28))<=$(=Date(Today()))"}>
}) InvoiceAmount

and

Sum({
<InvoiceDate = {"<$(=Date(Today()-28))"}>
}) InvoiceA

[Chanty4u]

Try this 

Sum({

   <InvoiceDate = {">=$(=Date(Floor(Today()-28)))<=$(=Date(Floor(Today())))"} >

} Amoun

t)

[danielaw]

Thank you, the restriction works, but it always returns me a value of €0. I would like a table or pivot table with the two variants (within 28 days, over 28 days) in the dimension and then the total of outstanding invoices as the key figure.

Any other ideas?

Sorry, I'm just a beginner and am currently struggling through my first large overviews.