Percent Calc

Discussion forum for PivotCubeX component. Common usage questions. Bug and problem reports

Moderator: Alex Zencovich

Percent Calc

Postby fabiano » Thu Jul 20, 2006 12:48 pm

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
fabiano
User
 
Posts: 16
Joined: Fri Jul 07, 2006 8:04 pm

Postby AlexZencovich » Thu Jul 20, 2006 5:11 pm

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%
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am


Return to PivotCube ActiveX

Who is online

Users browsing this forum: No registered users and 3 guests

cron