Forum Discussion

pavithra12's avatar
pavithra12
Regular Visitor
7 years ago

dynamic table filter using slicer selection

Here is my case,   I have three tables, crop_year,division and totals.   Totals is filtered based on crop_year and division. Divion is filtered based on crop_year, but as you can see due to c...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

I'm actually not seeing whatever images? you posted. Can you post some text so that it can be copied and pasted into a data model and then experimented upon?

pavithra12's avatar
pavithra12
Regular Visitor
7 years ago

Crop_Year table:

2015

2016

2017

2018

 

Totals table

2016    11    49   819   AL   2250

2017    11    49   819   PA   2250

2017    11    49   819   HP   2250

2018    11    49   819   HP   2250

2015    11    49   819   CM   2250

 

Division Table

2-Cental Division     2014

2-Cental Division     2015

2-Cental Division     2016

1-Mid Division         2017

 

So when crop_year 2017 is selected from the slicer (using crop_year table),

The totals table should display the 2017 data (2nd and 3rd row) and even the division table should display the 2017 data (4th row).

 

Thanks! 

 

  • riteshgaur's avatar
    riteshgaur
    Frequent Visitor
    7 years ago

    Hi Pavithra

     

    I saw your post ... were you able to solve this issue?

    I have landed up in same bucket now.