Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be with this
Sum(Total<Month> Sales)
Hi,
Try this.
Sum(total<Month>Sales)
Where Client and Month is the dimension.
Regards,
Kaushik Solanki
HI
PFA
Thanks - helped a lot!
In Straight Table Chart, take dimension as Month ans expression as sum(Sales). It will give you monthly total and grand total.
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.