6 Replies Latest reply: Apr 11, 2012 11:14 PM by Darwin Natividad RSS

    SIMPLE SET ANALYSIS:Date should be fixed but the dimension should change

    Darwin Natividad

      What I need is to create a simple pivot table. with RSM, Dealer and Dealer Rep as dimensions and have it fixed for 2011.

       

      So i was able to do it, but whenever i am trying to select a specific RSM, it won't hide those that should be excluded.

       

      I have attached the file. Any ideas?