Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Percentages of whole table instead of dimensions

Hi All,

I have the following table:

 Length Waist 30 31 32 33 34 35 36 38 40 32 50% (2 / 4) 67% (2 / 3) 70% (7 / 10) 58% (7 / 12) 60% (6 / 10) 100% (1 / 1) 90% (9 / 10) 0% (0 / 1) (0 / 0) 34 0% (0 / 1) 40% (2 / 5) 44% (4 / 9) 36% (4 / 11) 40% (4 / 10) 0% (0 / 1) 80% (8 / 10) 67% (6 / 9) 0% (0 / 1) 36 (0 / 0) (0 / 0) 0% (0 / 1) 0% (0 / 1) 0% (0 / 2) 0% (0 / 1) 0% (0 / 1) (0 / 0) (0 / 0) 38 (0 / 0) (0 / 0) (0 / 0) (0 / 0) (0 / 0) (0 / 0) (0 / 0) 0% (0 / 1) (0 / 0)

As you can see the percentages are based on the sum next to it, which is amount sold / amount delivered.

I want the percentage to be calculated as the amount sold against the TOTAL amount delivered. Any Idea on how to do this?

4 Replies
MVP

May be like this

Sum(Sold)/Sum(TOTAL Delivered)

Not applicable
Author

Thanks! This sort of works. Problem is, it calculates over everything, not seperated by dimension. For example. As a Dimension I also have customers. Now I need to calculate the totals per customer, not all.

Creator II

HI Maarten,