5 Replies Latest reply on Dec 5, 2018 3:46 AM by Shariq Mohd

    Action Filter Based on a Field which is not in Source viz but in target cross tab

    Shariq Mohd

      Hi All,

       

      I have a dashboard which is supposed to lead the user to a cross tab ("Details").

       

      Please see below.

       

      Sheet 1 : Shows the sales by product.

      Sheet 2 : Shows the orders by Segment.

       

      When filtered from "Sheet 1" , "Sheet 2" shows the number of order for that products in that segment.

       

      What i am trying to achieve: When the user clicks on any segment in "Sheet 2" the "Details" view should filter and show only 3 orders for the product selected in the treemap and the segment in "Sheet 2".

       

      Dashboard

       

      I am able to achieve the result however for that i have to add "Product Name" to the "Sheet 2" which makes the view look messy and confusing and the customer wont like it. See Dashboard 2.

       

      Dashboard 2

       

      i am attaching the .twbx here.