Best approach to populate missing dimension values in a budget file

[#1]

Hello,

I am trying to create a budget file where I want to 1) show past sales history as input for budgeting and 2) prepare a excel file for budget input. The challenge I have is that the budget input file need to hold all our product groups per customer while the granular history data only hold the product group that is purchased by the customer.

So for every "SoldTo" I actually need to show the product types: 301,302,303,304,305,306,307,308,399,401,402,403,404,405,501,502,503,504,505,506,507.

I have uploaded a sample file. Please let me know if you have any tips on this.

[ramoncova06]

if I understood right, you can use concat for this

[#3]

Hi,

Sorry, I did not explain this properly.

Below is an example of the end objective I want to achieve for all Sold To.

So it should be possible to input budget amount even if we have no historical sales for the customer and product group.

[ramoncova06 · Accepted solution]

so you mean something like this ?

you have to be a little careful if you have several  since I created a cartesian product to get all the product by soldto

[#5]

This works perfectly! Thanks a lot for your help!!

[ramoncova06]

glad it worked