I have 3 columns period ,invoice due date & amount in a single table.

[SumeetBankar]

I have 3 columns period,invoice due date & amount in a single table.

Now what i want is if period is last month 31-03-2022 and amount is 100,then i will check invoice due date of april and amount would be 30. So I want to show that 30 amount in my kpi.

[ribisht17]

This is not clear to me  and kindly post some data

Regards.

Ritesh

[SumeetBankar]

You can see in below image for the period of 31-12-2021, i'm getting invoice due date & amt 

But what I want to show as a Target in dashboard is the amt i'm getting in jan 2022 - 2334107463.

This amt i want to show as target in my dashboard

This is my base data

so I have invoice due date of every month but I want to show invoice due of next month so

if period is 31-12-2021 then due amt of jan 2022 , 

if period is 31-01-2022 then due amt of feb 2022 etc