Hi Cognos Experts,
I am facing an issue in dimensional reporting where,
I have a set with specific products on it in the rows of a cross tab and in coulmns i am calulating the growth % . Now I need to have an additional static column to show National average % for each product in the set .
Example - set(ProdA, ProdB, ProdC)
Crossttab
Sales Growth NationalSalesGrowth(Hardcoded)
ProdA 78% 23%
ProdB 65% 35%
ProdC 75% 56%
I have a calculated expression like this , but I am getting empty values ,even if i have ProdA its not returning 0.23 or 23%
if(caption(currentMember(Products Hierarchy))='ProdA')
Then(0.23)
Else
().
Is there any other way to get the desired result .
I also will have custom members in product set , where I combine tow products , in that case can I add the data item name in the caption .
Any help is appreciated .
Thanks,