4 Replies Latest reply on May 17, 2017 7:43 AM by oankar.agharkar

    how to apply table calculations to reflect on all reports on dashboard?

    oankar.agharkar

      Hello,

      I have a dashboard for gaming data. data is plotted on floor image to get game details and revenue per location.

      We have 9 week data period. in those 9 weeks(2 months) we have 2 games sharing the same position i.e

      position 1 - game A - 1st month

      position 1 - game B - 2nd month

       

      Here I am able to sum revenue amounts for position 1 on the image, but when we display revenues on pane, the amounts go off.

       

      Requirement : On Dashboard, I have to  filter on 4-26 or 4-27 (A_Map - workbook attached) and would need to display data same as it is shown on tooltip in all the dashboard panes above it.

      This works perfectly for position 4-21, 4-22 but not for next 2 positions.

       

      TWBX attached with dummy data. Requesting help from experts.

       

       

      Thanks,

      Oankar