Exclude one dimension in expression

Thu, 01 Nov 2012 10:26:41 GMT

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

Re: Exclude one dimension in expression

whiteline — Sun, 04 Nov 2012 10:53:08 GMT

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.