Summary Table

[#1]

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

[MK_QSL]

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])

[Gysbert_Wassenaar]

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.

[#4]

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

[Anonymous]

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.

[Agis-Kalogiannis]

You can create a dimensionless Straight table Piotr, and add only expressions to it.