Filtering Row List items dependent on Current Page - Line Item Value
I have a module with Employee List on the the Rows, Time as Columns and Line Items as Pages. I would like to Filter the Employee items on whether the Time Value selected is greater than zero for the Current Page Line Item
It seems you can use Current Page for all other dimension filters except for Line Items where you need to select a Line Item to use as your filter
I have solved the problem by what I call 'Transforming' the data. By that I mean that I created a Line Item Subset from the Line Items in the original module, created a replica of the original module with the line items removed and the Line Item Subset added. I then use Collect() & when you Filter you can use 'Current Page' on the Line Item Subset dimension
Yes I know I have broken all kinds of best practices by using FY21 rather than a dynamic value but this is for the FY21 Plan & I know next year the model will look completely different and these modules won't be used...still not best practice!
I just want to explain why you couldn't select "Current Page" in your situation.
Current Page, as you may know, means the current List Item; that translates to "apply this filter on any selection of this Particular List (Budget Owner, Currency.....etc)." Since Line Items are not a List, Current Page doesn't apply. That's why the LIS solution provided by @Yash1 works since the Line Items are technically a list now.
Einas "Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"