2 Replies Latest reply on Mar 23, 2016 5:06 AM by Dany Krivoshey

    Dashboard: using table as filter, but some values disappier in another charts

    Dany Krivoshey

      Dear all

       

      Will be great to have some help.

      See details below, also attaching the file.

      Have simple data: Year, Brand, Customer and Sales.

      Dashboard will include two containers:

      • 1 container with table 1  which shows sales per customer in 2015 and growth of sales for 2015.
      • 2 container  with table 2 which shows sales per Brand in 2015 and growth of sales in 2015.
      • Here is the trick, each container to be set up as filter: once I select customer in container 1, I will be able to see Brand performance in Table 2.
      • I built the dashboard but have a problem. Then I select the customer in Table 1 I see customer performance and growth, however Table 2 (Brands) can show only Sales, but growth is not shown..

       

      What is the problem and how to resolve it?

      Thank you in advance for your help.

       

      Thank you, Dany

       

        Data

      YearBrandCustomerSales
      2014XA100
      2014YA90
      2014XB80
      2014YB70
      2015XA120
      2015YA88
      2015XB75
      2015YB90

       

      DASHBOARD - Showing two tables, table 1 (Customer), table 2 (Brand).

      Customer Table is used as a Filter.

      DASHBOARD WITH SELECTION OF CUSTOMER - GROWTH IS NOT SHOW

      Selected the Customer A, Brand Table shows the sales, but growth is not shown.