+ Reply to Thread
Results 1 to 2 of 2

Cubeset Function with 2 criteria

  1. #1
    Forum Contributor
    Join Date
    02-20-2007
    MS-Off Ver
    2003 & 2007
    Posts
    299

    Cubeset Function with 2 criteria

    I'm trying to write a cubeset function that returns a ranked group. I can succesfully complete the functions if I leave out a criteria, but I need to have it filter based on the criteria to be useful. So this works fine, brings back all 'GenRptUnit's' & then i can use cuberankedmember to get the value i'm after:
    Please Login or Register  to view this content.

    However, I need to filter the 'GenRptUnits' to only bring back 'Wind', when i try to filter, i get #N/A, can't figure out how to do it, this doesn't work:
    Please Login or Register  to view this content.
    Any ideas?

    Thanks for your time and help.

  2. #2
    Forum Contributor
    Join Date
    02-20-2007
    MS-Off Ver
    2003 & 2007
    Posts
    299

    Re: Cubeset Function with 2 criteria

    Got It!! This works exactly as expected:
    Please Login or Register  to view this content.

+ 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. Suppress error message whilst cubeset and cubevalue update
    By samdthompson in forum Excel General
    Replies: 2
    Last Post: 07-17-2014, 05:58 PM
  2. Multiple exclusions from a cubeset
    By samdthompson in forum Excel General
    Replies: 2
    Last Post: 11-21-2013, 05:54 PM
  3. =CUBESET() formula. List all Dimensions in a Cube
    By olasa in forum Excel General
    Replies: 6
    Last Post: 05-02-2011, 02:58 PM
  4. Removing Child w/ Cubeset:
    By mjfii in forum Excel General
    Replies: 3
    Last Post: 08-18-2010, 04:48 PM
  5. CUBESET function for non-consecutive members
    By David Laplante in forum Excel General
    Replies: 2
    Last Post: 05-07-2010, 12:00 AM

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