Filter Issue

Hi,

 

I have a module with 2 lists (currency and tasks) as dimensions and a boolean line item.

Im trying to apply filter on the boolean line item, if TRUE then only the respective currencies satisfying the boolean condition from currency list should be displayed.

Im trying to apply filter but its not working as Task and currencies are in rows/columns.

 

I tried changing the pivot, made them on pages applied filter and again repivoted back to rows/cols, but it doesnt work.

 

Please can anyone help on this.

 

Regards,

Varshni

 

 

Tagged:

Best Answer

  • abhi1017
    Answer ✓

    Hi @Varshni3001 

     

    X Axis = Task list

    Y Axis = Currency list , Lineitem

     

    Applying filter ,will filter both task and currency list which is in X*Y format.

    1. Only Tasks which are true in all currencies will be shown. (For Summary= All)

    2. If even one currency is true in a task that entire row will be shown.(For Summary =Any)

    Hence , the filter might not respond as per requirement.

     

    Solution/Workaround :- If you nest both the lists in Rows/columns and filter it will surely work. (As depicted in above thread)

     

    ~ABhi

     

Answers

  • Hi @Varshni3001 

     

    How about you nest Task and currency in rows. Line items kept in columns. Now , Apply filter on Boolean line item.

    I tried replicating it ,check Screenshots below.

     

    abhi1017_0-1613650726916.png

    abhi1017_1-1613650778260.png

     

    Hope it helps.

    ~ABhi

     

  • Hello Abhi,

     

    The Tasks are on rows, Column have currency list and line items. 

     

    I need to apply filter on currency list i.e the boolean line item if true, should show the resp currencies.

     

    Regards,

    Varshni

     

     

  • @Varshni3001 

    You rows include Line Items so these need to be included in the filter module.

    Therefore, move your line items as a page selector or nest them with Task as a row.

    Your currency filter should now be available to apply against columns.

     

    Chris 

  • Thank you Chris.

  • Thank you Abhi.