3 Replies Latest reply on Dec 28, 2012 9:45 AM by Tracy Rodgers

    Hiding Date Range


      Hello All,


      In the below image, I have two measures. One that shows monthly apples, and one that calculates the YTD of those months. I am looking to collapse July-Oct of the YTD numbers, and show only Nov total, without collapsing the monthly numbers at the same time.


      The problem I am having is they share the same date dimension, so it seems as though any action taken to one, is done to the other. If I were to exclude one month under Apples, that same month would be gone under YTD Apples.


      Is it possible to "hide" a month range for just YTD Apples, but have the Nov YTD number still use the table calculation to come up with the Nov YTD number?


      Am I going at this in the wrong way?


      Any help is appreciated.