Help with graph showing percentages

[#1]

hi all,

I have a graph which shows 3 percentages, by month.

At the moment, the percentages seem to be worked out on totals across ALL time - yet I need them specific to the month that is being shown.

If I select a particular month from a list box it is fine...

my expression is:

SUM(HOURS)

/

SUM( TOTAL HOURS)

simple enough..

so how can I make it relate to the TOTAL in just the month (one of the dimensions)?

Thanks in advance,

Matt

[Jason_Michaelides · Accepted solution]

Hi Matt,

TOTAL will remove all dimensions from the calculations, but you can put them back one by one.  Try:

SUM(HOURS)/SUM(TOTAL <Month> HOURS)

Hope this helps,

Jason

[#3]

Thank you Jason, and apologies for the delayed response.

It is just what I was looking for.

Matt

[Jason_Michaelides]

Coolio.