2 Replies Latest reply on Jul 19, 2018 6:12 AM by Alex Braun

    IGNORE THE FILTERS ON A SPECIFIC CALCULATED FIELD

    vijay tyagi

      I intend combining three calculated fields to arrive at a total score, two of them need to draw data on the basis of selected month, while the third one on the basis of last 12 months.

      Can be viewed together on a dashboard where i can select separate time periods, but unable to get them as a single worksheet.

        • 1. Re: IGNORE THE FILTERS ON A SPECIFIC CALCULATED FIELD
          Joe Oppelt

          Vijay -- To do that sort of thing you usually need to have all the months in question in the underlying table for that sheet.

           

          When you say "the last 12 months", is that based on "today"?  Or is it based on the last date of data in your data source? If so, you can use LODs to grab sums of the last 12 months independent of any filters you have on the sheet.


          Alternatively, you can use a parameter to let the user select a month, and then display only a portion of the underlying table based on the parameter.

           

          Also, you can use a table calc as a filter to display the selected month.  That will leave the underlying table intact, even when you only display one month.  The other 11 months you need for the roll-up values would still be in the table to grab with another table calc.

           

          At a high level, those are ways to do what you are describing.  Without a specific workbook example, it's hard to give details on how to implement any of them.

          • 2. Re: IGNORE THE FILTERS ON A SPECIFIC CALCULATED FIELD
            Alex Braun

            You will need to use an LOD calculation for this, it allows you to ignore certain filters on your data. You can read more at the link below.

            Overview: Level of Detail Expressions