I have a powerplay report with 2 columns, 2001 sales by month and 2002 sales by month. I wish to add 2 further columns that are entered by the user which are predicted sales for each month by year.
Eg.
2001 -Actual 2001 - Predicted 2002 - Actual 2002 - Pred
123445 100000 232322 300000
202221 150000 123944 400000
. . . .
. . . .
Is this possible? I could hardcode the predicted into the cube design of course, but don't really want to unless I have to.
All help appreciated.
Eg.
2001 -Actual 2001 - Predicted 2002 - Actual 2002 - Pred
123445 100000 232322 300000
202221 150000 123944 400000
. . . .
. . . .
Is this possible? I could hardcode the predicted into the cube design of course, but don't really want to unless I have to.
All help appreciated.