Forum Discussion

eddd83's avatar
eddd83
Icon for Resolver I rankResolver I
7 years ago
Solved

count rows by month without creating relationship

In my table: X-High, High, Medium and Low are all measures. Total is just a measure summing the previous 4 measures. All-running total is the running total for the first 4 measures. X-high + hig...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    7 years ago

    I believe you can create a virtual relationship bewteen tables using the TREATAS function (never used it myself; so far have managed with inactive relationships and USERELATIONSHIP). Sorry I can't be of further help, but might be worth scouting the internet.

     

    Try here for example: TREATAS by enterprisedna.com

jtownsend21's avatar
jtownsend21
Icon for Responsive Resident rankResponsive Resident
7 years ago

That is really strange that it is messing up your table when you leave it inactive. That is what I would do. 

 

Can I assume you are leaving the relationship with the Task Completion Date active when you create the inactive relationship with the Due Date? 

eddd83's avatar
eddd83
Icon for Resolver I rankResolver I
7 years ago

When creating my original table, there were zero relationships in my data model.