How To Perform Calculations Over Dimension Items

Discussion forum for PivotCube VCL users. Common questions. Bug and problem reports

Moderator: Alex Zencovich

How To Perform Calculations Over Dimension Items

Postby mquesada » Sat Sep 09, 2006 12:13 am

Is there a way to perform a calculation over dimension items, lets say two (or more), to create a new one wich would be the result of the operation? For example if I have an item of Incomes and an item of expenses and I want to calculate a balance and show the result as a new item called Balance.
mquesada
Guest
 
Posts: 1
Joined: Wed Aug 23, 2006 9:39 pm

Postby AlexZencovich » Sat Sep 09, 2006 5:52 am

Create hierarchy item <Balance> with sub items <Income <Expence>. If all expence-related values will with minus and income with plus - balance will show sum of both.
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 VCL

Who is online

Users browsing this forum: No registered users and 11 guests

cron