Hi All,
I'm working on creating a crosstab that has multipe measures . Attached is the sample layout, it looks fairly simple but giving me tough time.
Here is what I did -
1) I dropped Sales and Quantity onto the Row area and created a calculation to display the Day Actuals.
2) For Full Month Forecast, I dropped a Crosstab Space with fact cell beside Day Actual column
3) Changed 'Define Contents Property' to Yes.
4) Created a query item at the intersection of Sales and Full Month Forecast with a calculation total([Sales Forecast] within set([Full Month])).
However, this doesn't seems to work, I dont see any value. Am I missing something or does it has anything to do with the context.
Regards
Raj
Hello All,
Fixed the issue.My bad, forgot to add the data items to the context.
I added a crosstab node member and included the required data items to the using the Property check box, this solved the issue.
Thanks everyone !!
Regards
Raj