Add forecast to pivot table based on query

I created a query and a pivot table, and now want to add a forecast.

The query outputs the following columns: Company, Area, Department, Year, Month, Total.

The pivot table is based on it and has the following settings:
Columns: Year, Month
Rows: Company, Area, Department
Values: Sum of Total

The year and month make up the last year, so, right now, for example, it lists 2022/5-2023/4, with a total for each year and a grand total.

fh8sdqhpp93b1.png

Now i want to add a forecast for the next 3 months on another tab. If i go to Data->Forecast->Forecast Sheet, the Create Forecast Worksheet popup has, "Use historical data to create a visual forecast worksheet" Then, "A forecast can't be created because the timeline isn't evenly spaced."

lvkfwic0q93b1.png


Is it a mistake to try to base the forecast on the pivot table?

Error was because of the total columns which can be removed under pivot table option and column options. I created date column in another tab with a formula, but then it said i had too much data. If i limited it to one row, it created the forecast, but that took up multiple rows, though i only had one per forecast. Instead, i used the average different over the last three months and just added it to the most recent total. That seems to work, for now.

pictures are useless, post an example excel file with manually created expected result and detailed description

> post an example excel file with manually created expected result

Not exactly my forte. In the meanwhile, i seem to have found a workable solution, so i'm good with that. I was just posting my solution in case anyone finds it via a search.

would be fine if you share solution here

Was the other post not clear enough?

you mean post#2 ?
that's ok

Yeah, that's what i did. And it stands until they tell me otherwise.

I usually don't read posts without attaching an example excel and that's why there are these questions
you should identify posts eg. solution
or who you are replying to
here there are two users at the moment so there is no problem but when there are more it starts to be problematic

good it's work for you
have a nice day

Ah, i marked it as solved. This was my first post here, and i didn't think anyone was going to see my reply after it fell so far behind.