Results 1 to 1 of 1

Thread: Dynamic / Multiple Slicer Selections

  1. #1
    Neophyte IH8DATA's Avatar
    Join Date
    Oct 2018
    Posts
    4
    Articles
    0
    Excel Version
    2016

    Dynamic / Multiple Slicer Selections



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all, it has been some time since I have posted here but I am stuck.

    In this case I am using CPG data and need help comparing a companies sales data to their competition. In the sample data you will see 4 unique entries for "Company", Acme, Acme Competition, Smart Div and Smart Div Competition. In this example I want to compare the sales for Acme against the sales for Acme Competition. Ideally I would have my user select a slicer for Acme (not Acme Competition) and display both the data for Acme & Acme Competition. Note that there will never be a comparison for Acme Div and Smart Div.

    I am trying to stay away from hard coding companies, such as a measure like, Acme Competition Sales:= CALCULATE( [Sales] , data[Company] = "Acme Competition" ). I am also trying to stay away from cubes.

    Hope this was *somewhat* clear.

    Thanks
    Attached Files Attached Files

Posting Permissions

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