Using Users Dimensioned Line Item in a Formula With No Users Dimension
I have L1 and L2 lists, and recently I added a new flat list as A, and A is actually acting like parent of L1 that determines the groups L1 list members belong to. Since I do not want to mess the existing hierarchy and model functionalities, I prefered adding A as a flat list.
In an L2 system module, I have an L2 and native users list dimensioned filter that filters L2 list members and their parents depending on selection of the list A member. Next, I have a summary module dimensioned by L2, and in that summary module, I use the filter line item I created in L2 system module, and it perfectly works and filters all the L2 and L1 list members. However, I want to use KPIs from the summary module, but as far as I know, line item summary settings show values for the whole list regardless of the filter. So, I want to use a new line item with an IF THEN statement that should reflect the line item values depending on selected list A members and will return 0 (zero) if it is not selected. Since summary module does not have users as a dimension it does not work.
Please let me know if you have a solution for this formula or a better solution in general the overall design of including the flat list A. Thanks