Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to filter Inter and Intra?

  Hi,   I need help with how to calculate and define the Inter and Intra ONLY. And in visualization, I need to show the total number for Intra and Inter. The screenshot is the rules that I n...
Need Help
Tips and Tricks
Tutorial Requests
dax's avatar
dax
Community Support
6 years ago

Hi vincentmo,

You could refer to my sample to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

    thank you for the reply.

     

    I believe is the opposite what I need. Because there are few rules that I must follow:

    - one name can only have one program

    - One person is associated with one program, however 1 person can publish >1 publication title

    - one title should either be Intra, Inter, Inter and Intra, or none of the above

     

     

    From the screenshot below, I created this in excel, and this is how I should calculate everything, and I tried my best to explain everything in note. The title is the most important column to filter or to calculate everything. And the reason I use colors because it depends on which title is in the program. Is very complicated for me, and I hope everything make sense. Again, thank you so much for trying to help.