Forum Discussion
ADDCOLUMNS and actual values return (e.g. text string)
The issue is that SUMMARIZE requires the initial <table> argument and there is no single table within the entire model that contains / correlates all values types ("A" --> "B" --> "C"). The other issue is the relationship type/flow from tables. For example, the table referenced within SUMMARIZE is table 3 - "T3 EDL to DWGS"- and value Type "C" columns are located in table 7 ("T7 EDL to NEEDS Table") which correlates Type "B" and "C". I've tried to use RELATEDTABLE() but it will not work due to multiple changes in table relationships (many-to-one, then one-to-many, then many-to-one, and lastly one-to-many again as T7 is reached)
I’m not quite clear about your current problem here. Could you please give some table samples with some data in them, and describe the expected output?
Best Regards,
Herbert