+ Reply to Thread
Results 1 to 3 of 3

Using Cube function to add two measures together

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2010
    Posts
    2

    Using Cube function to add two measures together

    I am using Excel 2010 so I cannot add a calculated field to an OLAP Pivot. Is there a way I can use a cube function to do the same.

    E.g. to have a single field that contains the combined value of two Measure fields

    Something like =CUBEVALUE("Connection","{[Measure].[Cost Price] + [Measure].[Mark up]}")

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Using Cube function to add two measures together

    I'm not clear about what you are trying to do.

    Can you upload a small sample file that shows both the data you are working with and results you desire, mocked up if necessary by hand typing them in?

  3. #3
    Registered User
    Join Date
    10-02-2014
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2010
    Posts
    2

    Thumbs up Re: Using Cube function to add two measures together

    Given two measures I would like to present a single calculated measure that adds the the other two together.
    So, for example, if my cube has two measures "Cost Price" and "Mark up" I would like to create a cube function that will add the two together and and present this as single measure "Selling Price".

    See attachment for example
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cube Root Function Procedure
    By bmr8002 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2012, 10:33 AM
  2. cube analysis add -in for excel and local cube
    By swetha in forum Excel General
    Replies: 0
    Last Post: 07-28-2006, 04:30 PM
  3. Cube root function
    By Alison in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-11-2006, 01:34 PM
  4. [SOLVED] cube root function
    By Alison in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2006, 08:50 AM
  5. Replies: 3
    Last Post: 01-10-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1