I was tasked to create a budget that shows the actual amounts from the beginning of the year up to a certain month (say Jan 2020 to Oct 2020) and budget category A amounts for the remaining months (say Nov 2020 to Dec 2020). Next, I need to show another column with the budget category B amounts. Finally (optional), subtract budget category B amounts from the hybrid budget (actual + budget category A amounts). With the native budget functionality, I can only select one budget category in the footer filter. I can't also show the specific budget category amount under Columns (since it depends on the footer filter). I was able to achieve though the first requirement (Actuals from Jan to Oct. + Budget Category A amounts for the remaining months). First column is actual, second column is budget category A amount, and third column is the sum of these two. For the second requirement, I tried to use custom segments in lieu of budget categories. But it's not possible to use it as a Column filter in the footer (once I add a budget amount column). So I used 'dummy' Classes as budget categories (since we are not budgeting per actual Class). It 'worked' but it also shows the first to third columns in the previous paragraph PER CLASS. (well this is what I expected too, I was just hoping). If anyone has a creative way to achieve this, that'd be great. Obviously, it's not possible through saved searches. For SuiteAnalytics, I think not too (in the budget root record, I can't find the actuals join).

You'll need PBCS or Solution 7 or Adaptive to do this.

I think NS will never improve its budget feature anymore since there is PBCS. Sigh. Is it really possible with Solution 7? If it's ok, do you know how much does it cost per month? Thanks!

Kevin, any idea about pricing for this tool?

Relatively cheap - definitely cheaper than PBCS.

@KevinJ of Kansas are you by any chance absolutely sure that it's possible in those 3 apps? Thanks! Just want to save some time 'cause the bundle owners sometimes say it's possible but during the demo it is not.

It's definitely possible with solution 7 to use more than 1 budget category in a single spreadsheet. I've a client that's been doing that for ~1.5 years.

Great! Thanks!