How are you identifying Product A and Product B here?
You can do a FIXED LOD calc that says SUM(IF [Product] = "A" then [value] END)
... and that value will be loaded onto every row in the database. And then you can have another calc that says
IF [Product] = "B" then [that LOD calc] ELSE [Value] END
This will leave you with a final calc that you would use as your measure instead of your original [value] measure.
So yes, it can be done.
Doing something like this would mean that I would have to use some hard coding right? It wouldn't be able to be automated?
Actually you could sort of automate it. You could have parameter that lets the user (or you) select which product is "A", and another for "B". Then instead of hard-coding "A" and "B" in those calcs, you would use [Param 1] and [Param 2].
I think I'm catching up to what you're saying.
In your previous calculation example, would [Product] be my product name or just the dimension? Secondly, "A" would be the product or a new variable we're assigning to it?
Lastly, what would the [value] mean in this situation? Would that have to be a hard-coded number?
Also, what does a fixed LOD calculation mean? Is that the fact that we have some hard-coded numbers we are working with?
Really appreciate your quick response.
Supply a sample workbook with some sample data. Tell me what product you want replaced with another product's info. (And what field (or fields) you want replaced.)