6 Replies Latest reply: Aug 27, 2013 10:54 AM by Steve Zagzebski

# TOTAL - Set Analysis

Data:

Client    Month   Sales

A             Jan       100

A             Feb        50

B             Jan        200

B              Feb       100

I know this should be simlpe but I am drawing a blank on how to incorporate the TOTAL function. What I want to be able to do is add the total for each month regardless of the client:

Object:

Client   Month    Sales

A          Jan        300

B          Jan        300

A          Feb        150

B          Feb         150

• ###### Re: TOTAL - Set Analysis

May be with this

Sum(Total<Month> Sales)

• ###### Re: TOTAL - Set Analysis

Hi,

Try this.

Sum(total<Month>Sales)

Where Client and Month is the dimension.

Regards,

Kaushik Solanki

• ###### Re: TOTAL - Set Analysis

HI

PFA

• ###### Re: TOTAL - Set Analysis

Thanks - helped a lot!

• ###### Re: TOTAL - Set Analysis

In Straight Table Chart, take dimension as Month ans expression as sum(Sales). It will give you monthly total and grand total.

• ###### Re: TOTAL - Set Analysis

I was slightly off in what I needed. I needed to segment by year:

Data:

Client    Month   Sales   Year

A             Jan       100   2013

A             Feb        50   2013

B             Jan        200  2013

B              Feb      100  2013

A             Jan        75   2012

A             Feb        50   2012

B             Jan        100  2012

B              Feb       75   2012

Object results:

Client   Month     Sales-2103   Sales-2012

A          Jan         300               175

B          Jan         300               175

A          Feb         150               125

B          Feb         150               125

Basically have to add Set analysis by year to this expression:Sum(total<Month>Sales)... but I must have my syntax wrong because I am coming back with blanks.