Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
sum(<Status> Quantity)
Is this the right syntax? Is not working...
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
Perfect. Thank You!