Hi,
I've created a crosstab report with month prompt as the selection. Now I need to give a defualt value for the prompt based on some condition.
Ex: From Dec 1 to Dec 5 = Default value is Oct 10; After Dec 5 = Default value is Nov 10.
Its a cube & I'm trying with Prompt Macro #prompt('p','mun','').
Pls give some sugesstions.
Any suggestion pls.