4 Replies Latest reply on Jan 31, 2017 9:40 AM by Jim Dehner

    Achieving dashboard based on aggregation of data

    Zeenat Goyal

      Hello All, I am trying to achieve a dashboard through tableau.

       

      Data hierarchy is  OG ->BU->Markets

       

      I already have aggregated data as rows in the table for OG level and BU levels along with individual market data.

       

      The requirement is I will select a particular BU as a parameter or filter, the table should display the OG level aggregate to which the selected BU belongs to and BU level aggregates and all the individual Market data for the metrics.

       

      The data source may be in Sample Data as in the attached excel sheet.  Can we get the output displayed as in the output worksheet based on the BU selection?

      could you help me or let me know what am I missing?

       

      Thanks in advance.