Forum Discussion
Problem displaying data for 3 tables.
I am trying to create a table, Item Master, that will contain data about Items. Most of the data comes from the AR_Inventory table, with an additional two columns coming from the Vendor table. Unfortunately, after adding columns to the "Table" visualization, I only see those that have a relationship. I want to show all the data from AR_Inventory with even empty fields for Vendor where there is no data.
Thanks. I solved it in a different way. I added a field from the intermediate table (ARINVT_VENDORS) to the visualization and it solved the problem.
Show items with no data - created a crossjoin in my visualization.
2 Replies
PKPK90 , Based on what I got. Create a measure with +0 and use
or use the option "Show item with no data"
Thanks. I solved it in a different way. I added a field from the intermediate table (ARINVT_VENDORS) to the visualization and it solved the problem.
Show items with no data - created a crossjoin in my visualization.
