Forum Discussion

artfulmunkeey's avatar
artfulmunkeey
Helper I
5 years ago
Solved

Help with custom multi-filter(?)

Hi all,   I am having some trouble creating a custom filter and am starting to think I am over complicating the problem. Could some one please be kind enough to offer some advice?   I have the fo...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    hello

     U can create a fact table for utilization type and map it to the other table. You can refer below. See below how I solved it. I hope this is what you wanted. 

amitchandak's avatar
amitchandak
Super User
5 years ago

artfulmunkeey ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

  • artfulmunkeey's avatar
    artfulmunkeey
    Helper I
    5 years ago

    Sorry for not being clear.

     

    I attempted to solve the problem through relationships, however, sometimes an activity type belongs in more than one Utilisation Type, for example; BD and External Projects need to appear in Productive and Billable categories (eventually I wish to use Utilisation Type to filter my data).

     

    I hope the below image is of further use.

     

    Thanks in advance!