Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

About creating custom calculated dimension Expand / Collapse
Author
Message
Posted Saturday, February 15, 2014 4:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 30, 2014 9:49 AM
Points: 2, Visits: 20
Hello,

Is there a way to create custom calculated dimension ?

For example: I want to do somethink like that,

Amount 2011 2012 2013 (Calculated) [2012]/[2011] , Calculated [2013,2012]
Material Name
Coca Cola 330ml 10.874 17.983 20.298 %65,37 %......
Coca Cola 500ml 20.482 29.372 30.487 %...... %......
Coca Cola 1000ml 7.874 9.486 10.387 %....... %.....


Best Regards
Post #1541837
Posted Friday, February 28, 2014 1:44 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486
So, for each year, you would like to calculate that year's total divided by the previous year's total?
Post #1546566
Posted Saturday, March 1, 2014 7:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 30, 2014 9:49 AM
Points: 2, Visits: 20
Actually yes
Post #1546637
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse