Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Matching Two Data Providors
- Thread starter ADB1
- Start date
- Thread starter
- #2
Sorted.....
- Create a variable that will be true only if records do exist on both sources:
True = If ( IsNull(<Revenue>) Or IsNull(<Language>)) Then 1 Else 0
- Insert a filter : Apply on value 0
- Hide the variable True : Format>Table>Pivot Tab>Click True, and then click Hide
- Create a variable that will be true only if records do exist on both sources:
True = If ( IsNull(<Revenue>) Or IsNull(<Language>)) Then 1 Else 0
- Insert a filter : Apply on value 0
- Hide the variable True : Format>Table>Pivot Tab>Click True, and then click Hide
- Status
Similar threads
