This content has been marked as final. Show 4 replies
Hopefully, there is a way to fix my current problem.
I have multiple tables in an application and for one straight/pivot table I need to show information related to two different tables in one row.
HID is one dimension and CostID is another dimension. Open date to completed date are all expressions that use data from one table with data related to HID.
ActualCost1 and ActualCost2 use information from a second table.
I want the cost of 50 and 30 to show on the row for the related CostID rather than show on a row with blanks which isn't useful.
Is there any way to get this work?