Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help with drillthrough filtering target table correctly

Hello I have a page containing a table summarising some sales information by customer. For example, there is a Revenue column that simply sums all Revenue for that customer, and a "Deal Revenue" c...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Glad to hear that!

    To share more ideas for other people who have similar problem,

    I make a test to achieve this.

    If i click on "Deal Revenue" column and drill through to Page3,

    When i add "Deal Revenue" column in the visual level filter(or page level filter) on Page 3, set"Advanced filter"->not blank,

    It would show correctly as you expected.

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

Glad to hear that!

To share more ideas for other people who have similar problem,

I make a test to achieve this.

If i click on "Deal Revenue" column and drill through to Page3,

When i add "Deal Revenue" column in the visual level filter(or page level filter) on Page 3, set"Advanced filter"->not blank,

It would show correctly as you expected.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.