Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have created two straight tables which show the results of two if statements. One has 3 results and the other has 2. I would like to create a separate summary table which has the check, so check 1 & 2, along with the number of results. Illustration below.
And is it possible to drill down from this, so get further information on the person with that name
Check 1
Name | Header 2 |
---|---|
Tom | 1 |
Paul | 1 |
Bill | 1 |
Check 2
Name | Header 2 |
---|---|
Jill | 1 |
Adele | 1 |
Summary
Check Number | Header 2 |
---|---|
Check 1 | 3 |
Check 2 | 2 |
Thanks for any help anyone can give
Iain
Check1:
Load *,'Check 1' as [Check Number] Inline
[
Name, Header 2
Tom, 1
Paul, 1
Bill, 1
];
Check2:
Load *,'Check 2' as [Check Number] Inline
[
Name, Header 2
Jill, 1
Adele, 1
];
Now create a Straight Table
Dimension
[Check Number]
Name
For 2nd Dimension, Tick Enable Conditional and write below in expression
IF(GetFieldSelections([Check Number])>0,1,0)
Expression
COUNT([Header 2])
Perhaps a straight table without dimensions and the two expressions from your other straight tables. Disable the total mode for the expressions and enable the Horizontal option on the Presentation tab.
Thanks for that, it worked. However the information I used was an example and I could have thousands of pieces of information that changes daily, is there a shortcut instead of typing that load in?
Thanks,
Iain
Hi Gysbert,
is there a way to create a straight table without dimensions? I have one with two expressions only and I think it needs at least one dimension.
You can create a dimensionless Straight table Piotr, and add only expressions to it.