"AdamB" <AdamB@discussions.microsoft.com> wrote in message
news:048E85B4-ECF8-495E-8E77-C90E44105A40@microsoft.com...
> Actually, what I ended up doing is referring to the Total Sales cell by
> using
> ReportItems!Total_Sales.Value. This worked for me, and is much easier
> than
> setting up a separate dataset
>
> "Jeff A. Stucker" wrote:
>
>> You can create a separate Dataset to retrieve the Total Sales. Then
>> refer
>> to that value in the calculation.
>>
>> --
>> Cheers,
>>
>> '(' Jeff A. Stucker
>> \
>>
>> Business Intelligence
>> www.criadvantage.com
>> --------------------------------------
>> "AdamB" <AdamB@discussions.microsoft.com> wrote in message
>> news:AE8B33DC-78FB-4B87-8A2B-F543E8E59C4B@microsoft.com...
>> >A have a Group, let's call it Menu Category. For a given Menu Category
>> >in
>> > this group, I need to calculate the percentage of this category's sales
>> > compared with Total Sales (which would be all the Menu Categories
>> > combined).
>> > How can I (from within my group), go outside the group to calculate
>> > Total
>> > Sales and use this value in the Group?
>>
>>
>>