Im prompting the user to select a Month in our Sales Cube Time Dimension.
Our crosstab report shows Selected Month Sales $, Prior Month Sales $, YTD Sales $, Prior YTD Sales $, Prior Year Total Sales $.
For the YTD Sales $, I want to show the Selected Year as column headings (ie 2014 YTD Sales $). Same for Prior YTD Sales $.
How do I add the selected year?
When I use a data item as Text Source it is just showing "--" as my headings.
Thank you in advance.
Hello kgcognos,
The data item on your crosstab column should have the definiton, something like:
[Your time dimension Month Level]->?Your Selected Month Parameter?
Then, as long as "Member Caption" is selected as the "Source Type" for the column it will display the caption for that selected month member.
-Cognos810
Yes, the column headings for Selected Month Sales $, Prior Month Sales $ and Prior Year Total Sales $ are displaying the member caption correctly.
But not the YTD Sales $ and Prior YTD Sales $ columns. My data item contains total(currentMeasure within set [YTD Set]) function.
It just display the name of my data item as columns. I wanted to add the year from the Selected Month. So if user select [2014/Jan], 2014 YTD Sales $ will show as headings.
Thank you.
In that case, select the column header and change the source type to Report Expression and then use substring on ParamDisplayValue, something like:
substring (ParamDisplayValue('Your month parameter'),1,position('/',ParamDisplayValue('Your Month Parameter')))
-Cognos810