How can I show this percentual?

[rcandeo]

I have a simple barcode graphic that has in it dimension year/month and status. The expression makes a sum of quantity sold.

I need to show in each month how much is sold for each status in percentual (for this I used relative).

The problem is that it works for one month. If I select more that one month, the percentual is distributed for all months, and I need to have 100% in each month.

How can I do that?

[blaise]

sum(<Status> Quantity)

[rcandeo]

Is this the right syntax? Is not working...

[josgil · Accepted solution]

Try:

Sum

(Quantity) / SUM(total <DIM> Quantity) Use number (no relative) with % as format

Where DIM it's the name of your first dimension variable or the name of group

[rcandeo]

Perfect. Thank You!