Percent Calc

[fabiano]

Hi, i have colunms show this:

value, quant, total, percent

100, 2 , 200 , 35
001, 3 , 003 , 45

Total colunm:
101, 5 , 203 , ? (40 (average) or 80 (sum) no good idea)

Lines ok, but total column percent? Which i calculate to use in the percentage, therefore it sum and average cannot be used in percetuais. Percent is colunm database select.

CalcType = ? (i dont know)

tanks

[AlexZencovich]

Sorry, I do not sure I could understand what you talking about.
Please note, percentage calculate as part of total (row or column) value.
For column totala (same for row totals too) percentage calulated as part of cube total value

Like if you have
-------- row total
2 2 2 2 8
3 3 3 3 12
4 4 4 4 16
--------- total
9 9 9 9 36

with peceents it will

by row percent

------------------------ row total calculated as percent along column
25% 25% 25% 25% 22.23%
25% 25% 25% 25% 33.33%
25% 25% 25% 25% 44.44%
-----------------------------------
25% 25% 25% 25% 100%


by column percent

------------------------ row total calculated as percent along column
22.22% 22.22% 22.22% 22.22% 22.23%
33.33% 33.33% 33.33% 33.33% 33.33%
44.44% 44.44% 44.44% 44.44% 44.44%
------------------------------------------------
25% 25% 25% 25% 100%