Filtering and Formatting Data

[tomtingley]

Hi,

I'm trying to create two outputs using the attached input file.

1) I want to create an output which shows all of the month's figures for the input file but for only "Payments" and "Level Expense (F)" in Column S of the input file.

E.G. Look something like this:

Forecast Type                         Jan 23                      Feb 23            and so on...

Payments                                 10,000                      200
Level Expense (F)                    5,000                        0

2) I then want to create a second output which uses a formula to add "Level Expense (F)" and "Payments" together for each month to look something like this:

Forecast Type                         Jan 23                      Feb 23              and so on...
Payments                                 10,000                      200

Level Expense (F)                     5,000                       0
Calculation                                15,000                    200

[FinnCharlton · Accepted solution]

Hi @tomtingley , here's one way to do this:

[MilindG · Accepted solution]

@tomtingley Heres one way to do it