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

    Hiding Date Range

    anthony.bednarczyk.0

      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.

       

      Thanks

       

      Image.jpg