4 Replies Latest reply on Sep 12, 2018 7:23 AM by Daivik Mehra

    Difficulty with previous calculation

    Daivik Mehra

      Good Day Tableau lovers!!! I am stuck in a pretty difficult situation. I have two widgets in my dashboards in which 1 widget shows the actual budget and the previous values for various period calculations like YTD, MTD, QTD, Previous 12 months etc.

       

      I have made the 12 months trend as a filter so that I can see the reflected changes in the other widget. I am able to get the actual and the budget values if I select a particular month from the 12 months trend. But I am unable to get the previous bar in the first widget.

       

      The screenshots below will make the statement clear.

       

                                                                          Widget 1

       

                                                            Widget 2