Exclude one dimension in expression

[#1]

Hi,

I have a chart with two dimensions:

Item Name

Group Name

Pls Note: An item can be present in multiple groups.

I need to show two expressions in my chart:

1. Stacked bar graph showing sum based on Item and Group.

2. Line graph showing cumulative % based only on Item.

Can anyone please suggest how can I exclude one dimension in second expression.

Regards,

Manisha

[whiteline]

Hi.

You can use total<> modifier to omit the dimensions in calculations.

For example:

=Sum(total<Item> Value)

calculates total sum discarding all dimension except Item.