I'm trying to make a Maser Item (Dimension) that will be a drilldown.
One Field I have (Work_Name)
The Second will be only the name of the Employee whom has the A or X Transcript Status for the Category.
But this doesn't work.
It's giving me the count but not the detail. Below is what I am applying to the drill - down in the chart.
So I have come to find out that the If Match statement I am trying to write within the Dashboard won't work. I believe I need to write it in the script. Here's my problem -
I have 5 SQL statements. I save them all to a QVD file and then I "drop" the table.
Then at the end I do an Inner Join on all 5 tables.
I want to create IF Match statements somewhere in there... I just don't know where or how I would do it. The Statements I need to create have fields from multiple SQL within the app.
The 5 Circled are my SQL Statements -
At the bottom of each is where I store the SQL to a QVD. See below.
Then I have my Inner Joins for the QVD files.
I want to create another SECTION to where I can write Conditions (IF Match) statements that could potentially have fields from multiple sections in one IF Match.
Any and all help on how to do this would be great.