Multple Calculated Measures in a Crosstab

[raj_aries81]

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

[raj_aries81]

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