Forum Discussion

jwhitlow's avatar
jwhitlow
Regular Visitor
5 years ago

Recalculate Grouped Table from Slicer?

I am trying to build a report of logins that contains two slicers, one for state and one for day type (weekday or weekend). I have a table of users. I created a reference to this table and applied some grouping. I created a small sample report of my report (below).

 

The State slicer is working as desired. The Day Type is not, however. It works fine for the top 4 items shown below, but not for the bottom 3. Those measures working from the Day Type slicer are all based on the main table. The bottom 3 do not respond to Day Type slicer since this table is static and does not have a Day Type column. My question is: Is there a way to have the referenced grouped table recalculate from the main table based on the applied slicer?

 

My tables look like this:

2 Replies

  • nvprasad's avatar
    nvprasad
    Icon for Solution Sage rankSolution Sage

    Hi,

     

    It's not possible to refresh the table by the slicer selection. Tables get updated only during On-demand or scheduled refresh.

     

    Appreciate a Kudos! πŸ™‚
    If this helps and resolves the issue, please mark it as a Solution! πŸ™‚

    Regards,
    N V Durga Prasad

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi jwhitlow ,

     

    It's not supported to create calculated table by the slicer value.

     

    Best Regards,

    Jay