+ Reply to Thread
Results 1 to 2 of 2

How to use OR filters for getting data from OLAP cube pivot table in Excel

  1. #1
    Registered User
    Join Date
    10-10-2019
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    2

    How to use OR filters for getting data from OLAP cube pivot table in Excel

    We are loading data from an SSAS model into an excel tabular form. The data within the spreadsheet needs to be shown using 2 conditions in OR way, I mean, I have 2 fields coming from the database: Original amount and amendment amount, We need display the information coming from the SSAS cube when original amount <=10.000 OR amendment_amount<=10.000.

    I tried to use the normal filters on Excel pivot tables, but it doesn't worked, because filters use AND implicitly to display information, I need OR.

    I tried to use the normal filters on Excel pivot tables (value and label filters), but it doesn't worked, because filters use AND implicitly to display information, I need OR.

    example:
    Code original amount amendment amount
    C1 25000 500
    C2 2000 18000
    C3 14000 9000
    C4 12000 10500

    Filtering by Original_amount<=10.000 and amendment_amount<=10.000 is noy displaying any records

    The result expected is C1,C2 and C3 code records displayed because one og the both conditions is true... How could I filter for displaying the right data?

    Using the example described above, the result expected is C1,C2 and C3 code records displayed because one of both conditions is true...

    results expected:
    Code original amount amendment amount
    C1 25.000 500
    C2 2.000 18.000
    C3 14.000 9.000


    How could I filter for displaying the right data?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: How to use OR filters for getting data from OLAP cube pivot table in Excel

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to "Post Quick Reply" button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

+ 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. Use macro to set filters in olap pivot table
    By Akash_C in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2015, 09:36 AM
  2. Replies: 1
    Last Post: 09-18-2013, 03:50 PM
  3. Pivot table HiddenItemList not working (OLAP Cube)
    By newbie11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2012, 06:38 PM
  4. OLAP cube Pivot table - too many records?
    By jamphan in forum Excel General
    Replies: 3
    Last Post: 12-21-2010, 06:36 PM
  5. Pivot Table - OLAP Cube
    By dlinvfc in forum Excel General
    Replies: 0
    Last Post: 01-30-2006, 08:30 PM
  6. [SOLVED] Pivot Tables with OLAP Cube - Dimension Properties Excel 2K
    By Jérémie Gent in forum Excel General
    Replies: 0
    Last Post: 08-05-2005, 04:05 AM
  7. [SOLVED] Will an OLAP cube or Pivot Table (or something else) solve my prob
    By Crimsonkng in forum Excel General
    Replies: 0
    Last Post: 05-23-2005, 05:06 PM

Tags for this Thread

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